Filtering database for items that contain any value from a list

Hi,

What is the best practice for searching the database for any records that contain a value that is held in a custom state list.

I am searching the database for any “Songs” that contain any of the text values that are in a custom state list of texts.

I tried the “Do a search for” and put the constraint to have one of these texts but it’s not seeming to work for me.

Thank you, any help is appreciated!