var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
mysql command help
I would like to replace a word with another word in a field under a mysql db.
Is there any sql statement that can help me to do it?
Thanks a lot.
use phpmyadmin easier
or there is so many fields you want to replace?
If you need to update a lot of rows, your best bet is probably writing a little Perl or PHP script that does a select to get all of the rows, and then loops through them and updates them one at a time.
Are you wanting to change the entire entry, or just a word inside a string. The first case is fairly easy; the second requires more work.
If it is the first case, you can do something like:
update TABLE_NAME_HERE set COLUMN_NAME='NEW_WORD' where COLUMN_NAME='OLD_WORD';