I am trying to run a meta_query with an array of values and have it search if all are present in the meta value which is stored in a serialized array. Is this possible?
My arguments for the query is as follows (note that this is nested in a class):
$args = array( 'post_type' => $this->posttype, 'posts_per_page' => '9', 'paged' => $paged, 'orderby' => 'meta_value_num', 'order' => 'DESC', 'meta_key' => 'lumens', 'meta_query' => array( array( 'key' => 'mount', 'value' => array('pendant' , 'wall'), 'compare' => 'IN' ) ) );
An example of the meta data stored, is in a serialized array similar to below:
My query will not return the appropriate results no matter what I try. I am realizing now that I probably should have stored each value in a different meta-key rather then in an array, however, there is far to many entries already to change the metadata now.