MySQL Substring Replace
Posted on Monday, June 8, 2009 in MySQL
Example will replace *.gif with *.jpg
UPDATE table_name SET image=replace(image,'.gif','.jpg');
Example will replace *.gif with *.jpg
UPDATE table_name SET image=replace(image,'.gif','.jpg');