Share on Facebook0Tweet about this on TwitterShare on Google+0Share on Reddit0Digg thisPin on Pinterest0Email this to someone

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') 
If you enjoyed this post, why not leave a comment or consider a Donation as a token of your appreciation. If you need help implementing something you saw on this site or any other project why not Hire Me?
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.

Loading Facebook Comments ...