5 lines
151 B
SQL
5 lines
151 B
SQL
-- Custom SQL migration file, put your code below! --
|
|
UPDATE files
|
|
SET url = regexp_replace(url, '^https?://[^/]+', '')
|
|
WHERE url ~ '^https?://[^/]+';
|