Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

SQL Command trouble with string values

Help
2011-02-07
2013-06-06
  • tom alberts
    tom alberts
    2011-02-07

    I'm new.
    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?

     
  • Jakub Vrána
    Jakub Vrána
    2011-02-08

    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'