Hint for mysql

18 years ago   •   1 min read

By Marcia Kadanoff

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. 


Spread the word