A column in my table contains email addresses.
I have a text string that contains the a few usernames of email addresses separated by commas. I can make text sting into an array if necessary to get my SELECT WHERE clause to work correctly.
Text string search argument is 'bob,sally,steve'
I want to produce a WHERE clause that only returns rows where the username portion of the email address in the table matches one of the usernames in my text string search argument.
Thus a row with
[email protected] would not be returned but
[email protected] would be.
Does anyone have a WHERE clause sample that produces this result?
Thanks.