MYSQL UPDATE command

Hi

I have a small problem in finding and replacing text in a field.

I know how to use UPADTE command and have lookup up regexp, but I can not combine them together.
I wish to change every occurrence of a myfield in mytable that has got QF in it to change it to GFI.
a typical data is : abcQFxyz to chnage to abcQFIxyz.

I got as far as:
UPDATE mytable SET myfield = QFI WHERE part_number REGEXP 'QF';
but I know that wrong.

Thanks for your help.

 

Maybe something like this:

UPDATE mytable SET myfield = REPLACE(myfield, 'QF', 'QFI');

 

You might want to check out http://www.php-groupies.de/blogs/archives/17-Regular-Expression-Functions-for-MySQL.html for some MySQL functions to do Replace operations with Regexps. Apparently Regexp Replace is still not in MySQL.