Filtering problem

… I will need to be more specific, by adding a “%” after $author
(James). The problem is that this will not work at all. Any idea why?

The % is a wildcard with a MySQL LIKE query, which I suspect you know. With meta queries, WordPress will add one to the beginning and one to the end of the string you provide. You can see that in the source. or just by var_dumping the query. By adding a % of your own, I suspect is throwing things off. By the time WP_Query and wpdb is through with it, it ends up looking like \\%%. I just ran a query through to check that.

Unfortunately the LIKE meta_query is not very flexible, but maybe you could sort it out with the get_meta_sql filter.

Related Posts:

  1. Combine tax_query and meta_query in WP_Query
  2. Query custom fields with three dates – start and end does not work
  3. Using meta_query, how can i filter by a custom field and order by another one?
  4. Mixing regular and custom post types (with meta_query) on home page
  5. meta_query for keys that aren’t yet set
  6. Fail to compare dates in meta_query
  7. Get posts based on meta key/value
  8. How to create a wp_query that contains both meta_query and tax_query
  9. WP_Query() show posts that end later than today
  10. WP_Query orderby custom field then post_date in one query
  11. Filtering a WP_Query meta_query by numeric values isn’t working
  12. Ordering posts having multiple post-meta date fields
  13. Querying custom post type with 2 custom fields (date-range)
  14. Custom Queries: Joining On Meta Values From Two Custom Post Types
  15. How Can I save multiple records in same meta key?
  16. modify all posts of a category to “no comments allowed”
  17. Order Posts by Taxonomy and Meta Value
  18. Ordering Post 2 Post admin meta box by meta from CPT
  19. filter search result with custom post type meta key
  20. I can’t set meta_key in my custom post type query
  21. order by meta_value serialized array
  22. Meta Query “IN” doesn’t work with ACF checkbox filter
  23. Using Query Posts With Multiple Post Types And A Taxonomy
  24. Create Pages from Database
  25. How do I write this SQL statement for Posts written in last 24 hours?
  26. Can’t sort order of wp_query with 2 meta keys
  27. Comparing timestamps in meta query doesn’t work
  28. Display two post types ordered by two custom fields
  29. query order by date on custom type: wrong order
  30. Used with meta_query in query_posts works slowly
  31. exclude custom post type by meta key in wp_query
  32. How loop through posts based on custom fields
  33. Custom query variable – get wordpress to redirect to nice permalink url
  34. Filter posts with meta_query NOT IN where value has multiple values
  35. Display custom post types with custom date field value (before today) & order by custom date field
  36. Query to change custom post type with specific category
  37. Displaying Metabox value (custom post type taxonomy)
  38. Query for custom post type objects in a taxonomy and with a meta value
  39. Display custom post type taxonomy and month
  40. Mass convert MySQL data entries into custom post type?
  41. Calculating Bayesian average for custom post type
  42. Meta_query with relation ‘OR’ killing server CPU
  43. CPT Meta Searching
  44. Filtering by Post Meta Custom Fields – Performance
  45. Ignore sticky posts if post is not in meta query
  46. Is it possible to apply a meta_query to one specific post type in a query with multilple post types?
  47. Query that joins the postmeta table twice
  48. meta_query compare >= not working but
  49. Deleting Custom Post type data using mySQL command
  50. advanced search forms with 3 input text and that the main problem 3 input text
  51. wpdb custom post_type problem
  52. Adding custom tables to WordPress
  53. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  54. Pull a post based on a meta value in a custom post type
  55. Setting proper query for multiple custom admin filters
  56. WP_Query: include custom post type only with specific meta value
  57. Sorting Custom Post Type by Meta Value but wont display when set to 0
  58. Insert post metadata for all posts in CPT at once if metadata no existent
  59. How to alter WP-JSON main query or best practise for custom endpoints
  60. Returning a list of custom post types excluding those without a specific meta_value
  61. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  62. Convert simple SQL Query to WordPress query
  63. wp_query check if integer exists in custom field’s array
  64. Filtering custom post type on a combination of custom taxonomies and custom fields?
  65. Get posts between custom dates
  66. filter custom post type by meta key in dashboard
  67. Meta query for custom post type ignored in main query
  68. How to filter wp_list_categories output with some custom post type meta query?
  69. Display a CPT based on a metabox selection
  70. A method for ordering mixed dates in search result loop (theory only, no actual code)
  71. How to do WP_Query with two meta fields with orderby clause
  72. Stuck in Order by more then one
  73. Meta Query Not Returning Output Despite Having Matching Values
  74. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  75. WP Meta query for a custom post type based on two values
  76. Why is this query not working? (Standard posts + custom post type)
  77. Using meta_query and tax_query at the same time
  78. Assign External Database Queries to Global Variables and Make Them Accessible
  79. How to import a custom MySQL DB table into a WordPress custom post type
  80. search suggest – filter post type
  81. Function causing the loop display posting more (empty)
  82. Meta Query posts not showing on ending date of custom field
  83. Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
  84. Configuring a meta query with multiple post types that have the same relationship on a single page
  85. Ordering custom post type by multiple custom fields
  86. How to Output which matched meta_keys were found from custom_type_posts?
  87. Possible to filter custom post type with multiple meta data?
  88. wp_insert_post sometimes fails after API call
  89. filter search custom field query
  90. How to let users choose where to search for posts?
  91. Query based on custom fields start and end date
  92. Proper way to display latest 5 posts grouped by post type?
  93. Front end access to a SQL data repository – recommended way?
  94. Navigate posts with different post type that are in the same categories
  95. WP_query – Filter by tax_query and meta_query using multiple select
  96. Is it possible to load a different sidebar in single.php based on a meta_query filter?
  97. Getting a custom post’s custom field based on another custom post’s custom field select
  98. Querying multiple values from a single key
  99. find custom post type post by searching its custom field with my string
  100. Update post if exist from PHP
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)