Hi, Again Aoineko from the french Wikipedia. Here is a good way of updating all articles that contain ' foo1 ' to ' foo2 ' ? Don't panic, I will not run this request just now ;o) It's just to know. There are many spelling errors we can solve with it (especially for french accent accent). What is the best time to run SQL request (not especially this one) ?
UPDATE LOW_PRIORITY cur SET cur_text = REPLACE( cur_text, '% foo1 %', '% foo2 %') WHERE cur_text LIKE '% foo1 %';
Aoineko