Search and replace in MySQL

For my future reference, searching and replacing some text in MySQL, via SQL.
Info from an article at The Media Tank.

UPDATE mt_entry
SET entry_text = REPLACE (entry_text, 'classlink', 'class')
WHERE entry_text LIKE '%classlink%'
AND entry_id="252";

Dunno why MySQL online manual gives a very basic example which is actually quite non-intuitive for figuring out solutions for “real-life” situations.

This entry was posted on Friday, January 16th, 2004 at 10:42 am. It is filed under Hindsight. You can follow any responses to this entry through the RSS 2.0 feed.

2 Responses to “Search and replace in MySQL”

  1. Dan says:
    17 January 2004 at 12:10 am

    test (to rebuild my blog)

  2. manuel says:
    10 March 2004 at 11:50 am

    yeah thanks for your pointer, the manual’s sample uses a select and is quite unuseful.. btw who’d want to replace “www” with “WwWwWw”???