I have a custom post type, Album, which has a custom field called 'tracklist'. Tracklist is a multidimensional array which contains a track title and track link, like so:
$tracklist = array(  => array( [title] => 'Stairway to Heaven' [link] => 'stairway.mp3' )  => array( [title] => 'Battle of Evermore' [link] => 'battle.mp3' ) );
I want to use get_posts to find all the albums with the song 'Stairway to Heaven.' Something like this (I know this won't work, but hopefully it will explain my intentions):
$albums = get_posts(array( 'post_type' => 'collection', 'meta_query' => array( array( 'key' => 'tracklist', 'value' => array( 'key' => 'track' 'value' => array( 'key' => 'title', 'value' => 'Starway to Heaven' ) ) ) ) ));
It's easy enough to use meta_query to look for a custom field that returns a single string, but in this case I'm looking a for a value buried a few levelsdeep. How would I do this?