MySQL 'WHERE AND' issue

Question

I've got an issue, I am trying to collect a number of defined emails from a database, I collect them via the ID of each client.

Therefore, I currently have 1000 users in the database and I only want the emails from IDs 10, 11, 23, 34, 56, 33, 340, 433, 434, etc...

Besides the "

SELECT email FROM users WHERE id=10 OR id=11 OR id=23 OR id=34...

etc" is there any other method that I could includes all the IDs simultaneously without having to write an OR condition each time and ID is added?

Thank you.

I've edited your question. In order to indicate the answer that helped you solve your issue, mark it as accepted. — Alexis Pigeon, Sep 10 '12 at 15:51

score 2 · Answer 1 · answered Sep 10 '12 at 15:44

2

Use the IN operator:

WHERE id in (10, 11, 23, 34, ....)

answered Sep 10 '12 at 15:44

Marc B

score 2 · Answer 2 · answered Sep 10 '12 at 15:44

2

Use IN

SELECT email 
FROM users 
WHERE ID IN (34, 56, 33, 340, 433, 434)

answered Sep 10 '12 at 15:44

John Woo

score 1 · Answer 3 · answered Sep 10 '12 at 15:45

1

SELECT email FROM users WHERE id IN (10, 11, 23, 34, 56, 33, 340, 433, 434);

answered Sep 10 '12 at 15:45

hjpotter92

3 Answers3