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

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.

Related Posts:

  1. order by numeric value for meta value
  2. numberposts? showposts? posts_per_page?
  3. $GLOBALS[‘wp_the_query’] vs global $wp_query
  4. Some doubts about how the main query and the custom query works in this custom theme?
  5. Set Alias for meta_query arguments in get_posts()
  6. How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?
  7. Loop within a loop?
  8. How to query only for products with status “in stock” in WooCommerce? [closed]
  9. Does WordPress sanitize arguments to WP_Query?
  10. How to get posts in different language from WPML Plugin [closed]
  11. WP_Query meta_query where meta value ends in space
  12. Highlighting Sub topic in a post?
  13. wp_query for the first sticky, then display the rest of the posts excluding the first sticky
  14. How to get any tag ID
  15. WP_Query with many meta_query arguments taking a long time to load
  16. how to retrieve specific product attribute value in an sql query?
  17. Slow speed and high CPU usage for my code. How to improve it?
  18. Multiple queries on Home Page – page load/site speed issue
  19. WordPress custom archive page
  20. query attachments of parent page if attachments of current page are smaller than …
  21. Show all parents and children in custom post type in right order
  22. Why is this coming back as null? Thats wrong. There is one post
  23. Retrieve featured image (thumbnail) url from multiple posts with one query
  24. WP_Query tax_query problem
  25. Only display authors who have posts
  26. wp_query() get_col error
  27. Update Loop with Form
  28. How to select posts from one category but exclude posts in another category?
  29. Query Custom Post Type Order By Taxonomy Field
  30. Exclude admin from WP_Query Contributors
  31. Order by custom table and multiplication
  32. WP_Query ajax loader detect end of posts
  33. WP_Query posts by distance based on LAT & LNG in Database
  34. exclude posts with a specific custom field and value
  35. Redirect page when URL parameter not set
  36. list pages using page.php and NOT page-{slug}.php
  37. Changing WP_Query params with url Query Var
  38. Moving the array pointer inside a WP_Query while loop
  39. From where is archive.php getting its posts?
  40. Help with WP_Query – Too many mySQL queries
  41. How can I make WP_Query get posts that have a tag but also have random other tags?
  42. Get a list of posts with associated meta_value
  43. Access WordPress query by index number outside the loop
  44. Pagination outside of loop
  45. Multisite – Global CPT – advices?
  46. Combine two queries into one to use in loop
  47. database query with more than a couple meta hangs and doesn’t complete
  48. Gallery shortcode numerical sorting
  49. Check return value of get_posts
  50. get_template_part causes 500 error
  51. Finding WordPress Posts assigned to multiple categories
  52. The most effective way to split by post type in custom query?
  53. Does meta_value (array) work with ‘orderby’?
  54. Get a list of posts by specific category
  55. WordPress Query String: get_posts(‘cat=5’) vs WP_Query( ‘cat=5’) vs URL: /site/?cat=5
  56. WP_Query – Adding “offset” posts to the end of the loop
  57. Shortcode for custom query not returning results when attributes are added
  58. wp_query is showing posts from other categories
  59. Multiple wordpress queries with nested output (odd – even)
  60. Get posts in taxonomy randomly
  61. Page navigation doesn’t seem to work when I add offset?
  62. it’s possible make a WP_Query with math operations?
  63. show posts with range meta key
  64. Using a Shortcode to List Posts from Multiple Categories
  65. How to display a list of posts in same child category as current post
  66. is_404() – where does this get set?
  67. wp_query on page template not working (Genesis framework)
  68. How can i show pagenavi in my author.php?
  69. WordPress | WP_Query does not return anything with s=a
  70. WP_Query Pagination
  71. Order by post meta not working with pre_get_posts filter
  72. Using Ajax and WP_Query to load more posts on category page fails
  73. ACF: How can I publish values of ACF fields in a loop while using wp_query?
  74. WP_Query random ordering not working since 5.4
  75. Where my home page and font options has gone?
  76. How to get the latest post list (of the parent custom custom type)
  77. Problem with my loops
  78. meta_query compare > not working
  79. 404 page on custom search pagination
  80. next_posts_link not visible on first page
  81. WP_Query about meta_key and its array value
  82. Query string order by custom field
  83. Paging works correctly on local version, but not live?
  84. Create global array to compare inside a query
  85. How to add in WP_Query to every 3 posts displayed? [duplicate]
  86. Paginate nested query of child posts
  87. Hi , i am trying to set the post for 24 hours and with it will be changed
  88. Own query vars are not displayed
  89. Show full category tree for a year with all post titles?
  90. Trying to use “Medium” featured image for custom post type on home page
  91. Get Current CPT taxonomy category in shortcode
  92. Display images with same specific value?
  93. WP_Query with meta_value_num and meta_query not paged correctly
  94. Sort Posts with custom meta key by default which is currently set as optional
  95. wp_query pagination links producing 404
  96. How return normal search result using wp_ajax action for wordpress
  97. Custom post types loop on a page template
  98. Pagination problem with multiple loops on the same page
  99. How to query posts from single post format on Genesis framework
  100. WP_Query filter Posts by timestamp event (range start and end) and by month (next 12 month)