How to have multiple WHERE values in mysqli_query?

Question

How would I use multiple values in the WHERE of a mysqli_query??

ex.

mysqli_query ($con, "SELECT post_title, post_content, post_date FROM posts WHERE post_id = 3013, 4140, 6850")

Is that the correct way to use multiple WHERE values? or...?

Please use the search. This is first of all a SQL question independent to the database client library used. — hakre, Jul 10 '13 at 14:51

score 4 · Accepted Answer · answered Jul 10 '13 at 14:47

4

use IN

WHERE post_id IN (3013, 4140, 6850)

which is the same with

WHERE post_id = 3013 OR
      post_id = 4140 OR
      post_id = 6850

answered Jul 10 '13 at 14:47

John Woo

score 0 · Answer 2 · answered Jul 10 '13 at 14:48

0

You need to use IN clause.

mysqli_query ($con, "SELECT post_title, post_content, post_date FROM posts WHERE post_id IN (3013, 4140, 6850)")

answered Jul 10 '13 at 14:48

Nasir

score 0 · Answer 3 · answered Jul 10 '13 at 14:48

0

Use IN:

mysqli_query ($con, "SELECT post_title, post_content, post_date FROM posts WHERE post_id IN (3013, 4140, 6850)")

answered Jul 10 '13 at 14:48

score 0 · Answer 4 · answered Jul 10 '13 at 14:49

0

First you should check the documentation:

And you seperate your where clauses with AND or OR

answered Jul 10 '13 at 14:49

Tobias Golbs

4 Answers4