Replace text in MySQL Database

Use tiny command to search and replace string in database

[sql]

UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");

[/sql]

thank you zimmertech