custom field - using multiple meta_key and meta_value in query_posts

admin管理员组

文章数量:1316408

how can i use multiple meta_key and meta_value in query_posts?

For example, I want to find multiple content with two different meta_key and meta_value. How do I do this?

i using this code but not effective:

query_posts('meta_key=test2&meta_value=hello&meta_key=test2&meta_value=bye');

please help me...

how can i use multiple meta_key and meta_value in query_posts?

For example, I want to find multiple content with two different meta_key and meta_value. How do I do this?

i using this code but not effective:

query_posts('meta_key=test2&meta_value=hello&meta_key=test2&meta_value=bye');

please help me...

• custom-field
• query-posts
• post-meta

Share Improve this question asked Dec 24, 2010 at 17:01 mehdimehdi 2511 gold badge11 silver badge55 bronze badges

Add a comment  | 

2 Answers 2

Sorted by: Reset to default 3

This is not currently possible with query arguments alone (realm of filtering raw SQL query and such).

If your task is not time-critical then I suggest to wait for upcoming WP 3.1 release. It will feature much more flexible querying capabilities for custom fields.

See Advanced Metadata Queries for post on upcoming improvements.

  $args = array(
        'post_type'         =>  'custompost_type',
        'posts_per_page'    =>  '1',
        'meta_query'        =>  array(
                'relations' =>  'AND', // you can use OR also as your requirement
            array(
                    'key'   =>  'serial-number',
                    'value' =>  '123'
            ),
            array(
                    'key'   =>  'model-number',
                    'value' =>  '456'
            ),
        ),
        'post_status'       =>  'publish',
    );
    $posts = get_posts($args);

if(sizeof($posts) > 0){
  var_dump($posts);
}

本文标签： custom fieldusing multiple metakey and metavalue in queryposts