Hint for mysql

When making massive changes to multiple templates within Expression Engine, we use a product called MySQL Studio available from Navicat in versions for Windows, Macintosh, and LINUX. The product allows you to manipulate MySQL tables using a graphical user interface and provides security over SSH. Beats the pants off of phpMyAdmin … in my humble opinion.

The query statement to change all templates to php_allow=“yes” is this:

update exp_templates set allow_php = replace(allow_php,’ n ‘,’ y ’ );

Likewise the query statement to change the input parse method to input is this:

update exp_templates set php_parse_location = replace(php_parse_location,’ o ‘,’ i ’ );

Of course, you don’t need Navicat to do this. You can also implement this query by calling up MySQL using a command line.