Batch update or replace in Joomla
Written by Joe   
Tuesday, 21 October 2008 07:13

Here is a simple and useful SQL that can help you batch operation in Joomla.

UPDATE jos_content SET `fulltext` = replace(`fulltext`,"OldWord","NewWord"); 

You can execute the SQL in phpmyAdmin or any other Mysql client.

 
Recommend Read