Untitled

mail@pastecode.io avatar
unknown
pgsql
11 days ago
521 B
6
Indexable
Never
UPDATE advertises
SET slug = REPLACE(LOWER(name), ' ', '-')
WHERE advertises.id is not null;

UPDATE advertises
SET canonical = REPLACE(LOWER(name), ' ', '-')
WHERE advertises.id is not null;

UPDATE projects
SET slug = REPLACE(LOWER(name), ' ', '-')
WHERE projects.id is not null;

UPDATE projects
SET canonical = REPLACE(LOWER(name), ' ', '-')
WHERE projects.id is not null;

UPDATE advertises
SET meta_desc = substring(
    regexp_replace("desc", '<[^>]+>', ' ', 'g'),
    1,
    156
)
WHERE advertises.id is not null;
Leave a Comment