Example usage of query with MySQL replace July 21, 2015 by admin UPDATE your_table SET url = REPLACE(url, 'test/1', 'test/2') WHERE url LIKE '%test/1%'