Doing a hard “find and replace” to the WordPress DB is a delicate matter, but sometimes necessary. Whatever your reasons, if you need to do so there are several plugins which will allow you to, or you can do it directly from PHPMyadmin with an SQL command.

A “find and replace” for a whole table in SQL is a relatively simple thing, but if you are running WPML on your WordPress site and want to target just the content in a particular language things get a little bit trickier…

Not a problem though, you can use this SQL command to achieve just this. Simply replace the text you are looking for, the new text it should be replaced with and the language code you are targeting.