Brian's Blog Homepage
correcting text
correcting text

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

J o o m l a !

Brian Teeman

Brian Teeman

Who is Brian?

As a co-founder of Joomla! and OpenSourceMatters Inc I've never been known to be lacking an opinion or being too afraid to express it.

Despite what some people might think I'm a shy and modest man who doesn't like to blow his own trumpet or boast about achievements.

Where is Brian?