Techheadz Tips and Tutorials
Xilo Reseller Webhosting
Enter Search Term
ID: 142 Category: MySQL Date Posted: 07/02/2010 Page Impressions : 1,127
0
Print How to Find & Replace Data in MySQL

How to Find & Replace Data in MySQL

If you have imported your database, only to find that funny characters have appeared, you can issue the following mysql statement inside PHPMyAdmin to find and replace. When using Find and Replace always be careful.
update tbl_name set table_field = replace(table_field,'replace_that','with_this');




 
Visit OSDisc for Linux & BSD Disks
Home | About | Links | Add Your Link | Most Popular | Last Accessed | Twitter | Site Map
Apache | CSS | HTML | Javascript | Linux |MySQL | Perl | PHP | Linux News & Games | Retro Computing | Ubuntu | Mint | Kubuntu | Win