• robertgres

• in reply to: Meta query with array as values
• May 21, 2021 at 7:23 pm

I’m pasting a note from original solution:

Given answer has potential to give false positives.

E.g. you’re after posts with IDs 528 and 76, but there are also posts with IDs 5287, 4528, 765 and 2769 which you don’t intent to get, but they might happen to match the rest of the query.

The same is true to any values, since matching “apple” will give you false positive on “apple_pie” or “applejuice” etc.

Internally arrays are serialized and look like

a:4:{i:0;s:3:"528";i:1;s:5:"15289";i:2;s:5:"apple";i:3;s:9:"apple_pie";}

note double quotes around values – which you can use to make sure that you’re matching exactly what you want

To safely query for values in them, just include quotation around value you’re after:

$meta_query[] = array(
    'key'     => 'checkbox',
    'value'   => sprintf('"%s"', $item),
    'compare' => 'LIKE',
);

You can also add colon before and semicolon after to explicitly telegraph your intention to query serialized value:

'value'   => sprintf(':"%s";', $item),

• robertgres

• in reply to: WP_query using meta_query for an ACF checkbox field
• May 21, 2021 at 7:20 pm

Given answer has potential to give false positives.

E.g. you’re after posts with IDs 528 and 76, but there are also posts with IDs 5287, 4528, 765 and 2769 which you don’t intent to get, but they might happen to match the rest of the query.

The same is true to any values, since matching “apple” will give you false positive on “apple_pie” or “applejuice” etc.

Internally arrays are serialized and look like

a:4:{i:0;s:3:"528";i:1;s:5:"15289";i:2;s:5:"apple";i:3;s:9:"apple_pie";}

note double quotes around values – which you can use to make sure that you’re matching exactly what you want

To safely query for values in them, just include quotation around value you’re after:

$meta_query[] = array(
    'key'     => 'checkbox',
    'value'   => sprintf('"%s"', $item),
    'compare' => 'LIKE',
);

You can also add colon before and semicolon after to explicitly telegraph your intention to query serialized value:

'value'   => sprintf(':"%s";', $item),