custom post types - meta query multiple values for the same key

admin管理员组

文章数量:1122846

I'm trying to query wordpress with multiple values but it looks like it can't take no more than 4 keywords

I'm currently using a loop and I already tried to switch to a IN operator but I need the query to work with wildcards and while REGEXP does the job, IN does not

foreach ($keywords as $value) {
    $args['meta_query'] = array(
        'relation' => 'OR',
        array(
            'key' => 'customfields',
            'value' => $value,
            'compare' => 'REGEXP'  
        )
    );
}

In this case $keywords is an array of words that I need to query to a custom field. It works with a few keywords, but it breaks with 5 or more.

I'm trying to query wordpress with multiple values but it looks like it can't take no more than 4 keywords

I'm currently using a loop and I already tried to switch to a IN operator but I need the query to work with wildcards and while REGEXP does the job, IN does not

foreach ($keywords as $value) {
    $args['meta_query'] = array(
        'relation' => 'OR',
        array(
            'key' => 'customfields',
            'value' => $value,
            'compare' => 'REGEXP'  
        )
    );
}

In this case $keywords is an array of words that I need to query to a custom field. It works with a few keywords, but it breaks with 5 or more.

• custom-post-types
• wp-query
• custom-field
• meta-query

Share Improve this question edited Jun 10, 2019 at 14:47 Pratik Patel 1,11111 gold badge1111 silver badges2323 bronze badges asked Jun 10, 2019 at 14:08 user169734user169734

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 0

Have you tried passing an array of values to the value argument?

$your_terms = array( 'foo', 'bar', 'baz' );

$args['meta_query'] = array(
    'relation' => 'OR',
    array(
        'key' => 'customfields',
        'value' => $your_terms,
        'compare' => 'REGEXP'  
    )
);

$this_query = new WP_Query( $args );

In its current form, your meta_query is overwritten in each iteration. In the final effect, you have only one custom field in meta_query:

Depending on the operator you want to use, meta_query argument should look as follow:

• for "LIKE", "REGEXP"

  if( is_array($keywords) && count($keywords) ) {
  
      $args['meta_query'] = array( 'relation' => 'OR' );
      foreach( $keywords as $value )
      {
          $args['meta_query'][] = array(
              'key' => 'customfields',
              'value' => $value,
              'compare' => 'REGEXP', // or 'LIKE'
          );
      }
  }
  //  === result: ===
  // $args['meta_query'] = array( 
  //     'relation' => 'OR',
  //     [ 'key' => 'customfields', 'value' => 'value_1', 'compare' => 'REGEXP' ],
  //     [ 'key' => 'customfields', 'value' => 'value_2', 'compare' => 'REGEXP' ],
  //     [ 'key' => 'customfields', 'value' => 'value_3', 'compare' => 'REGEXP' ],
  // );
  

• for "IN"

  if( is_array($keywords) && count($keywords) ) {
  
      $args['meta_query'] = array( 
          'relation' => 'OR',
          array(
              'key' => 'customfields',
              'value' => $keywords,
              'compare' => 'IN',
          )
      );
  }
  

本文标签： custom post typesmeta query multiple values for the same key