wordpress ajax relationship query

Look at the very last part of that query– LIKE '%\"17497\"%'. You are searching for any characters, followed by literally "17497", followed by any characters. I am pretty sure that is not what you want. I think you want any characters, followed by 17497 without the quotes, followed by any characters.

That means the meta_query is written incorrectly.

$meta_query = array(
    'key'       => 'lineup_artists',
    'value'     => $ArtistID,
    'compare'   => 'LIKE'
);

You don’t want to be adding your own quotes like that.

You also want to be checking that $ArtistID has a value before trying to use it, and you should be doing some data sanitization and validation before using information in $_POST. $_POST data is not safe data.

Related Posts:

  1. Using OR conditions in meta_query for query_posts argument
  2. How To Fix WP Query Returns Results But Shouldn’t?
  3. Include post content of linked posts in search
  4. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  5. WP_Query with “post_title LIKE ‘something%'”?
  6. Pagination with custom SQL query
  7. Is it possible to wrap Geo Location search around WP_Query?
  8. Is it possible to select against a post’s parent’s fields with WP_Query?
  9. How to make an activities stream mixing posts and comments?
  10. SQL Statement generated by WP_Query not producing expected results
  11. What is an efficient way to query based on post_meta?
  12. SQL query equivalent to WP User Query
  13. Recommended way to drop a pending query (in pre_get_posts)?
  14. how to retrieve specific product attribute value in an sql query?
  15. SQL User Query by Multiple Roles using PHP
  16. Advanced WP Query hogs the SQL server
  17. Query Posts depends on custom field inside repeater field using acf
  18. Query post with meta_query where date is not in future
  19. ACF – Get lowest & highest value from field
  20. WP User Query get all authors with last name starting with specific letter
  21. Select from wp_post and multiple meta_value from wp_postmeta
  22. How to correctly pass values to wpdb->prepare()?
  23. Sort users by “birthday” using WP_User_Query
  24. ACF Date Based wp_query
  25. Multiple taxonomy And acf filter group by
  26. List of the years with posts presented
  27. What is the random string I am seeing when I use get_query_var?
  28. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  29. Slow WP_Query for custom post type
  30. Complex WP SQL Query
  31. Any number in meta key (wp query)
  32. How do I run through a WordPress loop called from a filter function?
  33. Sorting events by descending date, and ascending time if multiple events on a date
  34. How can I display a custom field from all posts and order them individually from their parent post
  35. Editing the default wordpress search
  36. WP Query related posts by tags
  37. Order by summing multiple values
  38. Is there a way to work with a specific the_field from an already queried post? [closed]
  39. How to extract specific post
  40. Changing sort order for presentation by Jetpack infinite scroll
  41. Get all fields inlcuding “ACF” (Advanced Custom Fields) columns in wp_query
  42. How to pass orderby params to $wpdb->prepare()?
  43. Debugging wp_query orderby for taxonomy
  44. WP User Query with Custom Fields and Search Results
  45. Getting additional columns from sql
  46. JSON – Create rest api endpoint for Advanced Custom Fields
  47. Query where ANDing slug values not working
  48. Slow Query On Search
  49. WP_Query: apply an SQL function to meta fileld value
  50. Expecting statement error from php loop using ACF plugin
  51. Custom query filter by ACF date custom field
  52. How to avoid filling up an array each time I run a WP_query?
  53. How to SQL query posts IDs by categories AND authors?
  54. Randomly select one of last 3 posts
  55. WP Query orderby ACF boolean values and ACF field value
  56. Optimising WP_Query with ACF Fields
  57. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  58. Nearby locations using Advanced custom fields, maps?
  59. WP_Query – display posts by custom field and order by another
  60. Passing a SQL query to the WP Query
  61. WP_Query() not working as expected
  62. Excluding posts from search results page with meta query not working
  63. Form checkbox value going to dynamic URL
  64. ACF: How can I publish values of ACF fields in a loop while using wp_query?
  65. Any way to use FETCH_KEY_PAIR with $wpdb?
  66. What is the equivalent WP_Query of a SQL Query?
  67. create custom shortcode wp and put php code in
  68. Query for getting posts with their custom fields data in WordPress
  69. How to rearrange posts based on input field values added by WordPress “Advanced Custom Fields”
  70. WP Query with meta queries
  71. WP_Query, ACF field and array
  72. ACF query-pass field value
  73. Query string order by custom field
  74. ACF: using two loops, the_field returns field content from another loop
  75. Calculating efficiently on large amount of data generated by wp_query
  76. Get posts meta_query by repater field
  77. What argument does my function need to echo get_results() query results
  78. Wrap group of wp query posts to parent div by date/year
  79. Object of class WP_Query could not be converted to int inside shortcode
  80. Include post_status check within $wpdb query
  81. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  82. Wrote a WP Cron Plugin and it triggers a fatal error upon activation
  83. WP_Query within save_post doesn’t include the item that triggered the action?
  84. Issue in If else condition [closed]
  85. Can’t get the_content to show
  86. WP Query to order posts by multiple meta fields
  87. The sorting of posts by a meta_query with two keys fails while separated as single queries it works
  88. Get the type of an advanced custom field (ACF) in a WP_Query loop [closed]
  89. Creating array to compare custom field values
  90. How to return value from sql and display it
  91. WP_Query with several meta_query-statements and order by meta_value
  92. Display all custom meta field values from the database using ACF Repeater
  93. wpdb LIKE request shows all database data
  94. Output ACF field dynamicaly within a taxonomy loop [closed]
  95. Get posts using multiple values from ACF checkbox as meta query wordpress
  96. How do I subquery with custom meta fields?
  97. Add custom argument to WP_Query and modify SQL where clause
  98. Group By query based on Custom Field
  99. Best performance for use Custom Field in WP
  100. How to make OR condition in WP_Query