query_posts: how to show all ‘meta_value’ containing a specific word?

2 comments

1. No need for a custom query. Since 3.1, you can use a ‘meta query’;

   query_posts( array(
       'meta_query' => array(
           array( 
               'key' => 'meta_key_name',
               'value' => 'test',
               'compare' => 'LIKE'
           )
       )
   ) );
   

   Check out the codex on custom field parameters.

   Log in to Reply

2. by Using “Custom select query”

   <?php
   
    $querystr = "
       SELECT wposts.* 
       FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta
       WHERE wposts.ID = wpostmeta.post_id 
       AND wpostmeta.meta_key = 'tag' 
       AND wpostmeta.meta_value LIKE '%test%' 
       AND wposts.post_status = 'publish' 
       AND wposts.post_type = 'post'  
       ORDER BY wposts.post_date DESC
    ";
   
    $pageposts = $wpdb->get_results($querystr, OBJECT);
   
   ?>
    <?php if ($pageposts): ?>
     <?php global $post; ?>
     <?php foreach ($pageposts as $post): ?>
       <?php setup_postdata($post); ?>
     <?php endforeach; ?>
    <?php endif; ?>
   

   Log in to Reply