Multiple values in meta_key query

Question

I have a variable that looks like this

$the_vacancies_industry_areas_list = 'Call Centre','Child Care','Cleaning'

And i want to find if just one of these variables satisfies this case in a meta query

array(
'key' => 'industry_areas_list',
'value' => $the_vacancies_industry_areas_list,
'compare' => 'LIKE',


),

It only seems to satisfy if all three areas are present, not just one.

I want someone with just 'Child Care' or 'Cleaning' for example.

doublesharp · Accepted Answer · 2015-08-03 03:04:34Z

2

You need to set the relation type on the wp_query args to OR, then define each of the OR conditions as arrays.

$args = array(
  'meta_query'     => array(
    'relation'  => 'OR',
     array (
       'key'     => 'industry_areas_list',
       'value'   => 'Call Centre',
       'compare' => 'LIKE'
     ),
     array (
       'key'     => 'industry_areas_list',
       'value'   => 'Child Care',
       'compare' => 'LIKE'
     ),
     array (
       'key'     => 'industry_areas_list',
       'value'   => 'Cleaning',
       'compare' => 'LIKE'
     )
);

answered Aug 3, 2015 at 3:04

doublesharp

27.9k6 gold badges56 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

vrajesh · Accepted Answer · 2015-08-03 05:20:45Z

0

Try this: I made $the_vacancies_industry_areas_list as array variable and pass into wp_query

$the_vacancies_industry_areas_list = array('Call Centre','Child Care','Cleaning');

$args = array(
 'post_type' => 'YOUR_POST_TYPE',  //Set your post_type
 'post_status' => 'publish',  //Set your post_status
 'meta_query' => array(
  array(
   'key' => 'industry_areas_list',
   'value' => $the_vacancies_industry_areas_list,
   'compare' => 'IN'
  ),
 ),
);

answered Aug 3, 2015 at 5:20

vrajesh

2,9423 gold badges28 silver badges40 bronze badges

Collectives™ on Stack Overflow

Multiple values in meta_key query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related