Simon Wheatley

Tag: mysql

  • Escaping lists of strings for SQL in WordPress

    —

    by

    simonwheatley
    in

    Today I found myself wanting to use a query similar to SELECT DISTINCT post_id FROM $wpdb->posts WHERE meta_key IN ( ‘string_x’, ‘string_y’, ‘string_z’ ), but where I needed to construct the values for the list of strings from an array of untrusted values (because we never trust inputs, we always look suspiciously on them if…

  • Ordering post meta value, numerically

    —

    by

    simonwheatley
    in

    I have a client who wants to show a list of their posts ordered by the numerical value of a post meta field (custom fields are referred to as post meta data in the WordPress code, so I’ll be following that convention from now on). Unfortunately there doesn’t seem to be a way to do…

  • Exporting from MySQL to CSV

    —

    by

    simonwheatley
    in

    Everytime I need to do this I go into at least five minutes of Googling for a decent solution. The problem is that a lot of people don’t have access to the commandline, so the solutions all reference PHPMyAdmin which is, you know, OK, but I don’t use it or want to install it just…