Is it possible to filter in wordpress via wp_query() considering all fields?

Question

WordPress

Is it possible to filter in wordpress via wp_query() considering all fields? That is, all fields must be taken into account

'meta_query' => [
    'relation' => 'OR',
    [
      'key' => 'color',
      'value' => array('red', 'blue', 'white'),
                         'compare' => '='

    ],
    [
      'key' => 'price',
      'value' => array('20', '50', '180'),
                        'compare' => '='
    ],
[
      'key' => 'age',
      'value' => array('20', '30', '40'),
                         'compare' => '='
    ]
  ]

And at the same time, there are more than two condition fields. I found pictures, like this is implemented via wp_query(), but I can't find the code.

Answer 1

If "value" is an array then "compare" can only be: IN, NOT IN, BETWEEN, NOT BETWEEN.

'meta_query' => [
  'relation' => 'AND',
  [
    'key' => 'color',
    'value' => array('red', 'blue', 'white'),
    'compare' => 'IN'
  ],
  [
    'key' => 'price',
    'value' => array('20', '50', '180'),
    'compare' => 'IN'
  ],
  [
    'key' => 'age',
    'value' => array('20', '30', '40'),
    'compare' => 'IN'
  ]
]