How to: MySQL search and replace, PHPMyadmin, Joomla Params etc.

Reddit Diggit Facebook Twitter Flipboard Pinterest Linkedin WeiboBelow 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"')…