Guessing that your select field only stores on value, this means that it is a simple text value in the DB.
A checkbox field is stored as a serialized array in the DB, the same would happen for a select field that allows multiple values. To search by this field meta_compare
must be LIKE