Search and replace syntax

[asylu3]

If you want to search a certain key in mysql and replace with the new one. Here is the syntax you are looking for

[src]
update table_name set field_name = replace(field_name,'what_looking_for','replace_with_this');
[/src]

ex:
[src]
update tf_messages set posterid = replace(posterid,'99','0');
[/src]