MySQL REPLACE

Posted on | March 18, 2010 | No Comments

I’d not come across REPLACE as a MySQL function before. I’d always used a combination of concatination of LEFTs and RIGHTs and the occasional MID.

Unbelievable that I’d not found this function before…

SELECT REPLACE(fieldname, "look for", "replace with") FROM tablename;

So simple…

Comments