Untitled
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