How to find/replace in MySQL

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Helps me… thought it could help you too…  

Popularity: 1% [?]

Comments

  1. Simple, fast, efficient.

    I like it.


    Army Kate
    November 23rd, 2007
  2. Agreed… I use this all the time… love it.


    Jason
    November 23rd, 2007

follow me on twitter RSSSubscribe, Dude.