meta_query compare “=“ returns nothing when it seems it should

Figured it out from a comment made here.

The fix was to change this:

'value' => $p_specialty,

… to this:

'value' => '"'.$p_specialty.'"',

… and leave the LIKE compare as-is.

Just for more info, I had also tried serializing that value but that didn’t work.

Related Posts:

  1. How to check a single number value against an array of meta_key values?
  2. meta_query key value from array
  3. last_name + first_name orderby with meta_query [solved]
  4. meta query or with meta value
  5. WordPress meta query with meta serialized data array value
  6. Reading Content in an Array as it relates to a meta_query
  7. Trouble with calling an imploded variable in an array
  8. meta_query for user ID in array
  9. How to do a meta query using REST-API in WordPress 4.7+?
  10. Meta query terribly slow
  11. meta_query sorting by 2 keys
  12. Get result from meta_query() between two numbers
  13. How to handle optional end date in compare clause in meta_query
  14. Can I query custom meta data through WP_Query
  15. Using meta_query on pre_get_posts to exclude a particular meta_key value
  16. Query between two meta keys
  17. Archives for custom post type based on a “date” meta value
  18. How to query serialized array by comparing greater than (>=)?
  19. get_users meta_query
  20. Meta query with multiple logic (AND / OR)
  21. Best practice – Meta Query vs. post_clauses for “left join” ordering
  22. meta_query with multiple values
  23. Different page parameters inside query
  24. Return posts with specific meta key first, but the rest in alpha order by last name
  25. How to update single value in multi dimensional Post Meta?
  26. LIKE %…% Meta Query
  27. Multiple Values stored as array in Meta Query
  28. Order by nested named meta queries with ‘exists’ and ‘not exists’
  29. Documentation for post meta
  30. Advanced orderby with multiple meta_query
  31. Arrange Posts By Date In Order Of Closest To The Current Date
  32. Using get_terms() with meta_query parameters
  33. WP_User_Query with meta_query array relation ‘OR’
  34. WP Meta Query for some meta (array) values
  35. meta_query with array as value
  36. meta_query problem
  37. Custom Upcoming Events List for Events Manager Plugin
  38. Very slow query with meta_query on large database
  39. How to use meta_query to check if a meta field has something set?
  40. How to exlude posts that have certain meta_value?
  41. User Relationship
  42. meta_query results not the same with and without spaces
  43. Can an array be used as a meta_query value?
  44. meta_query all posts between to ages
  45. How to make a WP REST API query with meta_query in WP4.7?
  46. List of posts by day of the week
  47. WordPress Core – Optimizing meta_query generated SQL?
  48. Edit post_content on posts with Featured Image
  49. Nested Queries using meta_query
  50. Display no post when metavalue is 0
  51. Use both meta query and tax query
  52. Wildcard with LIKE operator in Meta query
  53. meta_query, number comparison, not quite working as it should
  54. Meta Query Compare with Date
  55. Query posts only if meta_value is not empty
  56. Does meta_query working with value paramater higher then 999?
  57. meta_query keys and sticky posts
  58. How to pass user meta_key and meta_value (values as array)
  59. WP_Query ordered by meta_value_num doesn’t fetch posts without this meta field
  60. Adding an array from a query string to a WP meta_query
  61. Query Multiple values for same key
  62. Custom post type archive with rand and meta_value
  63. Comparing a field with several values at once with meta_query
  64. Meta query with a sub query group possible?
  65. meta_query compare=’!=’ with multiple custom fields
  66. Query posts with numeric meta values within a given range
  67. Meta query: get posts with value in a multidimensional array
  68. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  69. meta_query not working on live site
  70. Display a CPT based on a metabox selection
  71. How to query post only with different excerpt?
  72. How do you get Posts by multiple meta_keys and meta_values with the Rest API V2?
  73. Query custom field with date
  74. Meta query with regular expression does not work
  75. Searching in title or meta, with a tax query too!
  76. WP_Query with meta_query no results
  77. Documentation for post meta
  78. meta_query issue with multiple numerics
  79. WP User Query Issues
  80. How to use meta query for greater than value in array?
  81. Wp Query custom search by meta query
  82. Pre Get Posts / Multiple Meta Keys / Orderby Single Key
  83. Filter posts by meta query?
  84. Help on multiple meta_query
  85. Meta query – How to display a null meta key
  86. pre_get_posts and set
  87. WordPress Screwing Up ‘orderby’ => ‘meta_value_num’ in ‘pre_get_posts’
  88. How to query wp_postmeta table for any specific meta_value?
  89. User meta query results in PHP notice: only variables should be passed by reference
  90. meta_query with multiple values optimization
  91. Meta query date column add [x] days to validate
  92. Grouping posts by a custom meta value
  93. Get a single post ID based on an exact match of 1 or more meta values
  94. How to use orderby with meta_query?
  95. wordpress Meta_query between numbers range (not working)
  96. meta_query with multiple key
  97. Orderby doesn’t work like expected on custom query
  98. I would like to have add_post_meta to return the ID instead of true or false
  99. Order by meta value
  100. Querying multiple values from a single key
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)