Multiple meta_values ​​use the same meta_key to query posts' custom fields

Question

Scenario: Posts have multiple entries with values ​​for the same key, for example a single post will have multiple meta_key [drink] => meta_value

[drink] => "Banana Juice"
[drink] => "Orange juice"
[drink] => "apple juice"

Want to find: posts that do not have an orange value in any entry with meta_values ​​with the same meta_key as drink.

Current method: using wp_query:

meta_query => array(array('key' => 'drink','value' => 'orange','compare' => ; 'NOT LIKE'));

Question: wp_query will still return posts with meta_value "orange" because it has other [drinks] with values ​​that are not "orange".

Answer 1

In SQL wildcard searches , you need to use the value %orange% in NOT LIKE.

does not have the % wildcard, and NOT LIKE has the same meaning as <> or NOT EQUAL.