how to search for unknown key(auto generated array index)

[MR-omid]

hi tom, user post form with value like this:

product[name]='name';
product[color][0]='red';
product[color][1]='blue';

i save colors to dynamic field and want to search for all

product where color is blue

or

product where color is blue and/or black

how to write query for this? note: i tested find_in_set and locate(if store colors as comma seperated list), but performance and multi value search issue. thanks and sorry for very poorly en :(