Select records with field value matching any one value in multi-select field?

Select records with field value matching any one value in multi-select field?

Is it possible to create a many-to-one query? 

Value of multi-select field for record 1 is (TEST1, TEST2)

Value of multi-select field in record 2 = (TEST1)
Value of multi-select field in record 3 = (TEST2)

Can I query the table to select record 2 and record 3 as matches for record 1, based on having one shared value rather than an exact match for both values?