Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE urls (
id int,
url varchar(255)
);
INSERT INTO urls VALUES (1, 'https://www.xxxx.com/file/0/fffd8ca225794d4c3c9f33a2ec321828/740000/740640/screenshots/1.jpg');
UPDATE urls SET url = REPLACE(url, 'fffd8ca225794d4c3c9f33a2ec321828/', '');
SELECT * FROM urls;