Using $wpdb to query posts with meta value containing current post_id

[Matt]

Hi Guys,

I am trying to to use $wpdb to retrieve a list of posts from the Database where the meta_value in the wp_postmeta table contains the current post_ID in inverted commas. eg. “10”

The inverted commas are the make sure that 10 doesn’t also match 100 etc.

I can get it work work when I paste the exact of the meta value ie: a:1:{i:0;s:2:”10″;}, however it is also returning all the revisions, not just the most recent post.

Here is the code I am currently using:

  $id = get_the_ID();
    $rows = $wpdb->get_results($wpdb->prepare( " 
    SELECT * 
    FROM wp_postmeta 
    WHERE meta_key LIKE %s 
    AND meta_value = %s 
    ", 
   'roles_%_production',
   '%"' . $id . '"%' 
 ));

        // loop through the results
        if( $rows ) {
        ......
        }

Any ideas would be greatly appreciated.

Thanks

Matt

[Chris]

You shouldn’t be creating custom SQL queries as WordPress has built in helper classes/functions that allow you to do this much more easily.

http://codex.wordpress.org/Class_Reference/WP_Query

[Author]

Posts