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
UPDATE jos_content SET introtext=REPLACE(introtext,'joomla','Joomla!');