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