I am trying to call all records in selected field that contain denoted strings.
This far in the SELECT statment I have:
WHERE field_name in('string', 'string2', 'string3')
This only seems to call records that match string, string2 and string3 exactly.
I tried the following:
WHERE field_name in('string%', 'string2%', 'string3%')
WHERE field_name in('%string%', '%string2%', '%string3%')
to wildcard the strings to return records where strings are containing within them. This didnt work.
Using MySql DB.