how can i modify a column by merely a few words?

Use simplest

UPDATE `table` 
SET url = TRIM(LEADING 'http://example.com/path1/path2/path3/' FROM url)

If the value starts from the specified substring – it will be trimmed, else the value will not be altered.

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top