Is "Ereg replace" possible ?

[atmaweapon]

Hi everyone !

I'd like to make a "query replace" using regular expression in my records... Is it possible ?
Something like this :
UPDATE my_table SET myField="\1bar\2" WHERE myField="(.*)foo(.*)";

I don't know if MySQL even permit this ... but I'd like to prevent me from making a php script which update every rows where the ereg is satisfied and replace the old one with a new one...