Create meta_query with relationship field?

• Teun

• September 23, 2016 at 5:16 pm

I want to create a custom WP_Query where I’m querying all posts with a certain relationship value, where the output is set as a Post Object.

The output of the field is:

 bedrijf => 
     0 => string(19) "a:1:{i:0;s:2:"16";}" 

The 16 in the example above, is the ID of the corresponding post.

When I try the query below, it just outputs all existing posts, not just the ones responding to the ID 16.

$args = array (
							'meta_query' => array(
								array(
									'key' => 'bedrijf', // name of custom field
									'value' => 16, // matches exaclty "123", not just 123. This prevents a match for "1234"
									'compare' => 'LIKE'
								)
							)
);

What is going wrong here?

Thanks!

• Teun

• September 23, 2016 at 5:32 pm

Actually, I found out what went wrong. I had another meta_query which overruled the one sent above.

Consider this question as solved.

• Mark_Kendall

• April 12, 2022 at 7:23 am

Just came across this answer and thought it best to point out the the example above would cause issues with an id that has 16 in as it would match 116,161,1216, etc. and so the quotes around the value are important as per the comment.

So…

$args = array (
    'meta_query' => array(
        array(
            'key' => 'bedrijf', // name of custom field
            'value' => '"16"', // matches exaclty "16", not just 161. This prevents a match for "1234"
            'compare' => 'LIKE'
        )
    )
);