Why posts array is empty?

You don’t need to add the % signs to the value. WordPress does that for you automatically on a LIKE or NOT LIKE comparison. You also don’t need to “sanitize” the parameter, it will be automatically escaped for SQL.

See wp-includes/meta.php, around line 806 or so.

Related Posts:

  1. How to know if get_posts() failed?
  2. How to give classname to post if post has no content?
  3. Related Posts function not working
  4. How to limit the number of posts that WP_Query gets?
  5. Should we trust the post globals?
  6. Random sort within an already sorted query
  7. How to get previous 10 days post from a specific date – WP Query
  8. WordPress Number of Posts Not Changing With posts_per_page
  9. How to add posts to wp_query result?
  10. Should ‘setup_postdata()’ be reset with ‘wp_reset_postdata()’?
  11. Search query – exact post title match
  12. posts_per_page doesnt work
  13. How to start with post number x?
  14. Exclude posts with empty post_content in wp_query
  15. Only display a certain number of posts, dependent on how many posts there are available in a query
  16. Improving WP_Query for performance when random posts are ordered
  17. Should $found_posts be returned as string in ‘found_posts’ filter hook?
  18. Get posts by name and taxonomy term
  19. Get Posts that are in the current month or later
  20. Exclude the first ‘n’ number of posts of a tag from home page?
  21. posts_per_page option limits the number of Gallery items
  22. How to get posts and comments amount per hour, per year and per month?
  23. Why Query is returning empty array?
  24. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  25. meta_value timestamp older than now
  26. Do not show children of a category
  27. Query for first 3 posts to change the look and feel
  28. Exclude some posts from displaying in wp_query based on some condition
  29. How to retrieve certain number of images from a wordpress post?
  30. How to convert query sql to shortcode in wordpress?
  31. How Can I Always Display A Particular Post First Using WP_Query?
  32. How to show multiple posts thumbnail, title and date in widget
  33. WordPress Query – Display 5 posts (same post type), each from a given tag
  34. Fill the exclude array() in get_posts()
  35. filter posts based on menu_order
  36. Show 5 posts and than 3 posts offset with pagination
  37. wp query custom orderby not custom field
  38. Sort / Filter Queries
  39. Advanced Post Display/Pagination/Ordering
  40. Why I obtain this WP_Query strange behavior trying to select posts having a specific tag?
  41. Why I have this strange behavior when I try to exlude the featured post from posts visualization?
  42. Retrieve latest post by multiple categories with ID
  43. Displaying Results From Custom Taxonomy Query
  44. WP_Query retrieve custom posts but not the post showing
  45. How to get single post by one author?
  46. Wp_query WooCommerce products
  47. posts_per_page – Repeats only first posts ‘post__in’ array
  48. get all posts ID from a category
  49. Accessing the post content with WP_Query
  50. is there a better way of combining this?
  51. How to output comments number of a post per day?
  52. If specific user role then sticky post
  53. Display posts with comments closed, with pagination?
  54. Only display posts after current date
  55. Encrypt / Decrypt Post Title and Details
  56. Custom WP_QUERY $args
  57. WP_Query Authors OR Categories
  58. Why is querying posts messing up my pages?
  59. Weird orderby => post__in issue
  60. How to do set post permalinks using 6 digit random unique function?
  61. get query() without post content?
  62. Any way for get_next_post() to use the actual post order instead of publish order?
  63. Dynamically switch template on click
  64. Get all custom post types excepted some…
  65. Get all comments of author’s posts
  66. Get posts with multiple categories
  67. How to get post content from an array of ids?
  68. Number of displayed posts
  69. Query posts and filter at query time by value of custom meta
  70. Getting blog pagination to work on page set as front page
  71. search blog posts by author first name and or last name
  72. Very complex post query
  73. Delete post revisions only for a single post
  74. unique post in “$args” of wp_query display more than one post
  75. How to display post list in a table layout (multiple queries in single loop)
  76. Not all posts showing in query
  77. WordPress query portfolio posts
  78. Get latest author posts inside the loop
  79. Show only posts with titles/permalinks that do not contain certain words
  80. Group first, 2nd, 3rd, etc posts by category terms
  81. Manipulated offset and pagination, can’t display last post anymore
  82. Query to fetch custom taxonomy along with post title
  83. How to fetch courses in all languages in WordPress?
  84. How to Get Position of a Post from a category and tag
  85. Is it possible to query a category with specified posts?
  86. Query posts from newest category
  87. WordPress loop uses unmodified posts array, why?
  88. Show posts between two Custom Fields date
  89. Query to get data of a post, if in category?
  90. Order posts by custom field
  91. Ordering posts alphabetically by meta keys and title
  92. Grab next post title in archive page
  93. Remove duplicated posts in the loop if post has more than one category
  94. Continuous listing from a custom field
  95. How to store post rating system data post independent?
  96. Why I getting only 1 post?
  97. First post in loop displays twice
  98. Filters do not work when there are multiple (one works)
  99. I am using the query block and what I want and see on the editor page is not the same with the actual results
  100. Batch Scanning and Deleting Empty WordPress Posts