mysql-search and replace value in a particular column

Change value of coloumn meta_value, replacing yes with no:

UPDATE `booksdb_8`.`wop_postmeta` SET `meta_value`=REPLACE(`meta_value`, 'yes', 'no');

You are reading this post on Joel G Mathew’s tech blog. Joel's personal blog is the Eyrie, hosted here.