Reply To: Meta query for post object?

• juliusbangert

• November 24, 2017 at 4:21 am

I have now read section 4 of that article, but I don’t really understand it because I’m not too hot on mySQL. But either way, I’ve added the following to my functions file :

function my_posts_where( $where ) {
    global $wpdb;
    $where = str_replace(
              "meta_key = 'authors_", 
              "meta_key LIKE 'authors_",
              $wpdb->remove_placeholder_escape($where)
    );
    return $where;
}
 
add_filter('posts_where', 'my_posts_where');

and I’m trying to query like this …

$images_query = new WP_Query([
    'posts_per_page' => -1,
    'post_type' => 'images',
    'meta_query' => [
        [
            'key' => 'authors_%_people',
            'compare' => '='
            'value' => ['85'],
        ],
    ],
]);

Any ideas why this wouldn’t be working? Could it be because I allow multiple values in the people post_object field?

What do you mean by “create a custom field for this query”?