Finding posts containing matching array elements in a meta field usign WP_Query

I believe you have to use meta compare LIKE. If you do a regular meta query, the resulting SQL will be meta_value = your_value, which is never going to find anything because it’s trying to match the entire contents of the field.