Help with a MySQL SELECT WHERE Clause
- by Dr. DOT
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.