I'm trying to duplicate a query from Adminer selecting/searching tables in the Adminer SQL Command window.
Note: I am using the WordPress plugin version but running Adminer in a seperate tab.
Example as given when selecting/searching in a table using the Adminer GUI:
SELECT * FROM `wp_term_taxonomy` WHERE `taxonomy` = 'post_tag' LIMIT 90
When I put the same chars in the SQL Command window, I get an error and:
SELECT * FROM `wp_term_taxonomy` WHERE `taxonomy` = \'post_tag\' LIMIT 90
But phpMyAdmin works fine.
Is there some trick to using string vars in Adminer that I am missing?
Try to use standalone Adminer first (download). If it helps then please contact the WordPress plugin author. If not then please specify your Adminer and PHP version and send the output of phpinfo.
Current i will check this on the plugin; maybe WordPress add an filter to all get and post-params and fitler the'