Mass replace in mySQL

Have a webpage with 2000 articles ?
Need to replace a certain keyword with a new one?

Use the string below.

UPDATE tablename SET fieldname = REPLACE(fieldname, ‘the text you want to replace’, ‘new text goes here’);

One comment

  1. james weaver says:

    Nice, thanks for the code. Would you be interested in in sharing links?

Leave a Reply

Your email address will not be published. Required fields are marked *

*

View Corey  Schario's profile on LinkedIn