Untitled

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;