MySql Update LIKE %...%

[iNod]

Hello All,

I am looking for a mysql statement that would allow me to update a particular section of a mysql field. For example

"Hello,

FGjgkg
Gkfdgjhgkf

Gjkfgjk

<a href="gjgfkfg.com">GJHGDfg</a>

Cheetoss
"

I would like to change <a href="blah.com">gfjdgk</a> to GFHGDfg

Is this possible? Even if I have to run one sql statement 4 times for each part. (change <a href=" to [url=" for the first one, and so on)

- Steve

 

[Eric]

Possibly http://dev.mysql.com/doc/refman/4.1/en/string-functions.html#function_replace

# REPLACE(str,from_str,to_str)
UPDATE table SET field = REPLACE(field, '<a href="blah.com">gfjdgk</a>', 'GFHGDfg') WHERE id = 1;

If I understand correctly.