Meta query: get posts with value in a multidimensional array

You can’t, at least not efficiently. You best bet is to use the LIKE statement, but it would fail for searches like “title”, “link”, “mp3” 🙂

I suggest you build your own serialization method. For example, store the tracklist as a string like this:

Track1 title
Track2 title

Notice the new line character (\n). Use it to split the string into an array when you need to use the meta value.

Then you can have something like:

..
'meta_query' => array(
    array(
      'key'   => 'tracklist',
      'value' => 'Starway to Heaven',
      'compare' => 'LIKE',
    )
  )
...

The download links can go into a separate meta record.

Related Posts:

  1. How do you get posts by meta_query using the JSON API plugin?
  2. meta_query date and time comparisons
  3. Serialized array, grab specific posts with meta_key/meta_value[0]->is_featured
  4. Only showing the_date and the_excerpt for first entry in get_posts
  5. get_posts() using an array of post ids [closed]
  6. Get all posts with a certain meta key, except for one with specific title
  7. Array merging multiple get_posts throwing Undefined offset error
  8. Using get_posts, I need to use a combination of OR & AND relations
  9. How do I get posts by multiple post ID’s?
  10. setup_postdata() does not seem to be working?
  11. Regenerate Slugs From Title of Posts
  12. Why get_posts are only showing five posts (retrieved by assigning a category to them?
  13. WordPress get_posts by category
  14. Alternative to get_posts() due to multithreading cache crash
  15. Can I query custom meta data through WP_Query
  16. How to get current post ID in quick edit callback
  17. How to restore deleted pages/posts?
  18. get posts based on meta value of the author
  19. date_query not returning some posts in date range
  20. How to query serialized array by comparing greater than (>=)?
  21. Query all posts where meta value is empty
  22. Why favour the standard WP loop over iterating over (new WP_Query())->get_posts()?
  23. Query posts ordering by title, but ignore ” and special characters
  24. How to check a single number value against an array of meta_key values?
  25. Meta Query with date and time on the same Day before given time
  26. How to update single value in multi dimensional Post Meta?
  27. get_posts not honoring post_status
  28. get_posts only children from certain parents
  29. WP Meta Query for some meta (array) values
  30. meta_query with array as value
  31. use get_posts to get custom field data, but in one array
  32. Filtering custom post type query
  33. get_posts from post x(offset=>x) to end
  34. With get_posts(), how can I put a category as a variable
  35. How do I combine these 2 queries
  36. Increase the page size of the WordPress REST API
  37. Cache Get_posts
  38. get_posts() returns all posts rather than the ones specified with ‘post_author’ =>
  39. Query random post from different categories
  40. get_posts() excluding all children of a specific post/page
  41. `get_posts()` ignore my custom post
  42. excluding current post from get_posts
  43. How to query posts to include specific pages of one post type, and all pages of another post type?
  44. Only retrieve posts where post_excerpt has been filled out
  45. Can I use numberposts=-1 and offset together when using get_posts()?
  46. Ordering posts in get_posts
  47. Adding an array from a query string to a WP meta_query
  48. Better way to list links with different meta values using same meta key?
  49. Meta Query returns wrong number of posts
  50. How to get the post content from a category on my homepage
  51. get_posts() not working in functions.php
  52. Get posts by list of post IDs ordered by those IDs?
  53. Display post details by post ID
  54. What is the p parameter in a get_posts() parameter array?
  55. Delist entries in the_loop
  56. Inserting post content into pages when using custom taxonomies
  57. Output meta into arrays
  58. Get posts in between specific ID’s
  59. How to use WordPress Conditional Tags in get_posts foreach loop
  60. Don’t submit post if post title exists
  61. Turn get_posts as string into an array for use in theme admin options
  62. Hide gravity forms
  63. Why would get_posts be ignoring posts with 2-digit ids?
  64. Querying multiple values from a single key
  65. Order custom post type by custom field (created by PODS) via PHP
  66. get_posts( $args ) return empty data
  67. get_posts returns all posts
  68. Check if searched number is within the post meta value
  69. WordPress Random post (last 3 days posts)
  70. Fetching All Posts (200+) in a Category – Performance Issues?
  71. Can’t get Category link inside get_posts
  72. List all pages including archive
  73. How do I get only a certain number of images from a post (minus the featured image)?
  74. Yet another get_posts() in explicitly defined order problem
  75. List random posts on single page in the current category
  76. Divide the list into two columns (get_posts)
  77. WordPress & MySQL , problem with use many array in meta_query
  78. WordPress echoing content in seemingly random place
  79. How to use get_posts to filter against a single post id?
  80. WP get_posts meta_query using ACF repeater field
  81. Why set cookie from URL parameter doesnt work all the time?
  82. get_posts filter meta_query using ACF Checkbox
  83. How to get posts by meta value as multi-dimensional array?
  84. Is there a way to extract a single post better than using get_posts()?
  85. WP_User_Query Orderby Not Working
  86. Custom Category widget
  87. get_posts – check if custom field has content?
  88. Get Posts from Custom Meta Query
  89. Why does ‘meta_key’ return an empty array in get_pages
  90. Slow query when selecting with large meta query or post__in
  91. How to exclude posts with empty and non-existent relational custom field with meta_query?
  92. Use not custom fields in get_posts() meta_query?
  93. How to Retrieve Post ID of another page
  94. WordPress – List Sub Categories and Sub-Sub Categories, With Posts
  95. Sorting posts by specific order
  96. Sorting not working with get_posts
  97. posts_per_page – Repeats only first posts ‘post__in’ array
  98. WordPress extremely slow when using get_posts with multiple meta_query relations
  99. How do I have multiple metaqueries inside one wordpress query
  100. post__in select all custom posts and not the selected array of ids