Mysql database migration and special characters

While doing Mysql Database migration we used face the special characters issue.
Check this link for more details to rectify the special characters issue..

http://www.orthogonalthought.com/blog/index.php/2007/05/mysql-database-migration-and-special-characters/

i hope it will help!

String Replace in Mysql

UPDATE table_name   SET value= REPLACE(value,"dev","content");


here Value refers the column name;
ex:
if column value has "test_something" its replace "live_something" if we write the query like this below


UPDATE table_name   SET value= REPLACE(value,"test_","live_");