Here is a great tip that can save you hours of work. Sometimes you have messed up characters in your database - wrong character encodings - or you want to strip out some text in a certain table's field. In phpMyAdmin, open up the SQL dialog and use the following code (change tablename and tablefield to your name and field values):

Code: Select all

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

You can also tack on a WHERE statement, if you like.

In addition to the above find and replace in phpMyAdmin,

kwok wrote:

Code: Select all

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

you can also create a conditional search and replace like this:

Code: Select all

UPDATE `tablename` SET `tablefield` = '0' WHERE `anotherfield` = 'condition' AND `tablefield` = '1'