Reply To: get select value in meta query

• John Huebner

• August 1, 2016 at 1:07 am

That depends on if you want to get posts with both values or with either value (AND/OR).

// AND
$args = array(
  'post_type'      => 'cafe',
  'posts_per_page' => 12,
  'rewrite' => array( 'slug' => 'cafe', 'with_front' => true),
  'meta_query' => array(
    array(
      'key'     => 'cafe_state',
      'value'   => $cafe_state,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_area',
      'value'   => $cafe_area,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_name',
      'value'   => $cafe_name,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_facilities',
      'value'   => '"test"',
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_facilities',
      'value'   => '"tests"',
      'compare' => 'LIKE',
    ),
  ),
);

// OR

$args = array(
  'post_type'      => 'cafe',
  'posts_per_page' => 12,
  'rewrite' => array( 'slug' => 'cafe', 'with_front' => true),
  'meta_query' => array(
    array(
      'key'     => 'cafe_state',
      'value'   => $cafe_state,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_area',
      'value'   => $cafe_area,
      'compare' => 'LIKE',
    ),
    array(
      'key'     => 'cafe_name',
      'value'   => $cafe_name,
      'compare' => 'LIKE',
    ),
    array(
      'relation' => 'OR',
          array(
            'key'     => 'cafe_facilities',
            'value'   => '"test"',
            'compare' => 'LIKE',
          ),
          array(
            'key'     => 'cafe_facilities',
            'value'   => '"tests"',
            'compare' => 'LIKE',
          ),
     ),
  ),
);

You should be cautious when adding additional meta queries because the slow down site performance.