UPDATE LOW_PRIORITY cur SET cur_text = REPLACE( cur_text, '% foo1 %', '% foo2 %') WHERE cur_text LIKE '% foo1 %';
oups, copy&past error :o) here is the right version:
UPDATE LOW_PRIORITY cur SET cur_text = REPLACE( cur_text, ' foo1 ', ' foo2 ') WHERE cur_text LIKE '% foo1 %';
Aoineko