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');