Search and Replace

This post is here because in the last 3 weeks I must have googled for the answer about 5 times.

How do you search and replace a word in a database using phpMyAdmin?

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

So if I wanted to change every occurance of "joomla" to "Joomla!" in the articles of this site I would use the query window of phpMyAdmin and type. Remember to change jos_ to the prefix for your own site.

UPDATE jos_content SET introtext=REPLACE(introtext,'joomla','Joomla!');

UPDATE jos_content SET fulltext=REPLACE(fulltext,'joomla','Joomla!');