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:
- How do you get posts by meta_query using the JSON API plugin?
- meta_query date and time comparisons
- Serialized array, grab specific posts with meta_key/meta_value[0]->is_featured
- Only showing the_date and the_excerpt for first entry in get_posts
- get_posts() using an array of post ids [closed]
- Get all posts with a certain meta key, except for one with specific title
- Array merging multiple get_posts throwing Undefined offset error
- Using get_posts, I need to use a combination of OR & AND relations
- How do I get posts by multiple post ID’s?
- What does setup_postdata ($post ) do?
- Query for custom post type? [closed]
- setup_postdata() does not seem to be working?
- Regenerate Slugs From Title of Posts
- get_posts – get all posts by author id
- Why get_posts are only showing five posts (retrieved by assigning a category to them?
- Exclude Current Post from Recent Posts Loop
- WordPress get_posts by category
- get_post random and order by not working
- Alternative to get_posts() due to multithreading cache crash
- Can I query custom meta data through WP_Query
- How to get current post ID in quick edit callback
- get_posts with meta_compare=’LIKE’ not working
- How to restore deleted pages/posts?
- Sort “get_pages” by menu order not ordering
- get posts based on meta value of the author
- date_query not returning some posts in date range
- Get the exact SQL query that get_posts() generated
- How to query serialized array by comparing greater than (>=)?
- Query all posts where meta value is empty
- Why favour the standard WP loop over iterating over (new WP_Query())->get_posts()?
- Query posts ordering by title, but ignore ” and special characters
- How to check a single number value against an array of meta_key values?
- get_posts inside cron
- Meta Query with date and time on the same Day before given time
- How to update single value in multi dimensional Post Meta?
- meta_query key value from array
- get_posts not honoring post_status
- get_posts returning empty array
- get_posts only children from certain parents
- Problem with get_posts, tax_query and counting the number of posts
- WP Meta Query for some meta (array) values
- Loop through two different sets of custom fields
- get_posts cannot grab from specific category
- meta_query with array as value
- use get_posts to get custom field data, but in one array
- Filtering custom post type query
- Check If posts exist in custom post type category, outside of loop
- data returned from get_post($postId) have different keys than wp-json/wp/v2/posts/{postId}
- How to limit get_posts()?
- get_posts from post x(offset=>x) to end
- With get_posts(), how can I put a category as a variable
- What’s the difference between “get_posts” and “wp_get_recent_posts” when used with “setup_postdata”?
- How do I combine these 2 queries
- Show post only if match all categories
- get_posts gives different result than wpdb->get_results
- Increase the page size of the WordPress REST API
- How do I output a database option that is an array into a get_posts array?
- How to generate a list of posts published on current day?
- Can an array be used as a meta_query value?
- List of posts by day of the week
- Trouble using get_post
- Cache Get_posts
- Get latest posts from multiple categories
- get_posts() returns all posts rather than the ones specified with ‘post_author’ =>
- Query random post from different categories
- Get_Posts, only if in both categories
- Posts not showing in correct Alphabetical or ID order when using get_posts / orderby but only on production server
- get_posts() excluding all children of a specific post/page
- Secondary Query Is Breaking Main Query
- If clauses in get_posts query
- var_dump and print_r cause white screen
- `get_posts()` ignore my custom post
- excluding current post from get_posts
- How to query posts to include specific pages of one post type, and all pages of another post type?
- Only retrieve posts where post_excerpt has been filled out
- Can I use numberposts=-1 and offset together when using get_posts()?
- Ordering posts in get_posts
- I don’t arrive to do order_by title when i have a conditionnal year in a request
- How can I display a single post link, based on title sample and change monthly?
- Adding an array from a query string to a WP meta_query
- get_posts() doesn’t consider user permissions
- Get posts inside Get terms problem
- Better way to list links with different meta values using same meta key?
- Display a CPT based on a metabox selection
- Weird orderby => post__in issue
- Stuck in Order by more then one
- Ho to add get_relative_date and post_except to this get_latest_post query?
- How to update all posts but the current one (post__not_in not working?)
- Get posts with multiple meta values
- Meta Query returns wrong number of posts
- meta_query issue with multiple numerics
- How to get the post content from a category on my homepage
- get_posts() not working in functions.php
- Query Problem in getting top viewed posts
- get_posts not working as expected
- Get all pages and posts with get_pages() or get_posts()
- Getting only a specific post type with get_post?
- Get posts by list of post IDs ordered by those IDs?
- Display post details by post ID
- What is the p parameter in a get_posts() parameter array?