Below are a few SQL statements I use to search and replace the value of params in Joomla, in this case I added another value.

UPDATE  `joomla_database_name`.`j15_modules` SET  params = replace(params, '"cache":"0"', '"backname":"1","backlink":"1","cache":"0"') WHERE  `j15_modules`.`module` ="mod_menu";

Here is another statement to search and replace a value in the entire database table:

UPDATE `joomla_database`.`j15_content` SET `desc_population` = replace(`desc_population`, '2010', '<br />2010') 
How to: MySQL search and replace, PHPMyadmin, Joomla Params etc.
Tagged on:                                             

Leave a Reply

Your email address will not be published. Required fields are marked *

2 thoughts on “How to: MySQL search and replace, PHPMyadmin, Joomla Params etc.