# mySQL Multiple Select from name field

**URL:** <https://forum.kirupa.com/t/mysql-multiple-select-from-name-field/151573>\
**Category:** programming\
**Created:** [June 16, 2005, 1:29pm UTC](https://forum.kirupa.com/t/mysql-multiple-select-from-name-field/151573 "2005-06-16T13:29:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zaid\_W1red](https://avatars.discourse-cdn.com/v4/letter/z/cab0a1/32.png) [@Zaid\_W1red](https://forum.kirupa.com/u/Zaid_W1red)\
**Post date:** [June 16, 2005, 1:29pm UTC](https://forum.kirupa.com/t/mysql-multiple-select-from-name-field/151573/1 "2005-06-16T13:29:01Z")

</div>

Im SURE this is a really simple problem but what ever syntax I try i just cant get what i want.

Basically, I have a mySQL table, and i want to select variouse rows based on the email address…in a mix of english and roughly guessed SQL would read:

SELECT \* FROM table WHERE email= ‘someone’, ‘someone else’, ‘somemore’

Returning in this case three rows…

I hope thsi makes sence, id really appreciate it if ANYONE can help!