Get posts by meta value

Question

I would like to list all posts that have a key of cp_annonceur with the value professionnel.

Answer 1

What you are asking for is a meta_query

$args = array(
   'meta_key' => 'custom-meta-key',
   'meta_query' => array(
       array(
           'key' => 'cp_annonceur',
           'value' => 'professionnel',
           'compare' => '=',
       )
   )
);
$query = new WP_Query($args);

All of the information you need is in the Codex.

Answer 2

There are two ways to do that:

1. Intercept the main query on pre_get_posts:

   add_action( 'pre_get_posts', function( $query )
   {
       // only handle the main query
       if ( ! $query->is_main_query() )
           return;
   
       $query->set( 'meta_key',   'cp_annonceur' );
       $query->set( 'meta_value', 'professionnel' );
   } );
   

2. Add an additional query

   $second_loop = get_posts( array(
       'meta_key'   => 'cp_annonceur',
       'meta_value' => 'professionnel',
   ) );
   

A more throughout example can be found in this answer.

Answer 3

I used custom select (might be better performance)

$posts = $wpdb->get_results("SELECT * FROM $wpdb->postmeta
WHERE meta_key = 'cp_annonceur' AND  meta_value = 'professionnel' LIMIT 1", ARRAY_A);

Inspired from https://tommcfarlin.com/get-post-id-by-meta-value/

Answer 4

We can get the desired result with Meta query of the WordPress :

// the meta_key 'diplay_on_homepage' with the meta_value 'true'
$cc_args = array(
    'posts_per_page'   => -1,
    'post_type'        => 'post',
    'meta_key'         => 'cp_annonceur',
    'meta_value'       => 'professionnel'
);
$cc_query = new WP_Query( $cc_args );

For more detailed guide regarding meta query follow this blog : http://www.codecanal.com/get-posts-meta-values/

Answer 5

You can easily grab the posts using WordPress's built-in function called get_posts You can find more details about get_posts here https://developer.wordpress.org/reference/functions/get_posts/

$posts = get_posts(array(
    'numberposts'   => -1,
    'post_type'     => 'post',
    'meta_key'      => 'cp_annonceur',
    'meta_value'    => 'professionnel'
));

Answer 6

Try this, It's working for me

global $wpdb;
$meta_key = '_request_body';

$data = $wpdb->get_results($wpdb->prepare( "SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = %s", $meta_key) , ARRAY_N  );

$result = [];
foreach($data as $array){
    $result[] = $array[0];
}

print_r($result);