Apr 19 2010

Replacing text in MySQL text fields

Category: Coding, by James @ 2:46:51 pm
Web-design

I didn’t even think you could do this:

UPDATE table SET something = REPLACE(something,'oldtext','newtext');

How handy! For replacing text in MySQL tables that is… not for anything else really.

« A solitary person screeched at this... »

One Response to “Replacing text in MySQL text fields”

  1. Jasper says:
    April 19th, 2010 at 5:31 pm

    Yeah, I like that one. Shame you can’t do regex replace, though.

Leave a Reply