Untitled

 avatar
unknown
pgsql
a year ago
662 B
7
Indexable
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,
    155
)
WHERE advertises.id is not null;

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