Query posts with custom field is array

Question

I'm using ACF to create custom field of select type. I used like this to create custom select field like this:

1 : Anh
2 : Hai
3 : Hoang
4 : May
....
12 : Lan

I use this query to search posts have value is 1 (Anh) like this:

                 URL for query :   /?thename=1
                 $thename = $_GET['thename'];
                 $args = array(
                            'post_type' => 'interviews',
                            'post_status'    => 'publish',
                            'posts_per_page' => $perpage,
                            'paged'          => get_query_var('paged'),
                            'meta_query'    => array(
                                    'key'       => 'thename',
                                    'value'     => $thename,
                                    'compare'   => 'LIKE',
                                )

I searched like this but it returns wrong results. I think the value of thename field is array (value and label) then It is not possible to use query above.

So can you suggest me to do with this search? Thanks.

mikerojas · Accepted Answer · 2022-03-14 16:07:55Z

1

Your meta query should be an array within an array... update the meta_query like below:

'meta_query' => array(
    array(
        'key'       => 'thename',
        'value'     => $thename,
        'compare'   => 'LIKE',
    )
)

answered Mar 14, 2022 at 16:07

mikerojas

2,3481 gold badge6 silver badges7 bronze badges

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

Comments

Siavash · Accepted Answer · 2022-03-14 20:20:26Z

1

According to the meta_query documentation meta_query must contains one or more arrays, so your query must be something look like this :

'meta_query' => [
  [
    'key'       => 'thename',
    'value'     => $thename,
    'compare'   => 'LIKE',
  ]
]

answered Mar 14, 2022 at 20:20

Siavash

3882 silver badges10 bronze badges

Collectives™ on Stack Overflow

Query posts with custom field is array

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