Untitled
unknown
pgsql
a year ago
521 B
10
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, 156 ) WHERE advertises.id is not null;
Editor is loading...
Leave a Comment