Menu

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.

     
  • Nobody/Anonymous

    Current i will check this on the plugin; maybe WordPress add an filter to all get and post-params and fitler the'

     

Log in to post a comment.