Tuesday, July 21, 2009

Mysql Search and Replace

Use this query to search and replace in mysql.

update 'tablename' set field = replace(field,'search_item','replace_item');

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails