mysql select query with multiple WHERE

Question

I need to select few rows in 1 query by it's ID , for example here is something that i wrote

SELECT * FROM posts WHERE post_id = "15 , 14 , 14"

how can it be done in real sql query?

Scott Harwell · Accepted Answer · 2012-01-11 15:26:05Z

8

SELECT * FROM posts WHERE post_id IN (14,15);

answered Jan 11, 2012 at 15:26

Scott Harwell

7,4652 gold badges31 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Riz · Accepted Answer · 2012-01-11 15:26:36Z

5

SELECT * FROM posts WHERE post_id IN ( "15" , "14" )

answered Jan 11, 2012 at 15:26

Riz

10.3k8 gold badges43 silver badges54 bronze badges

Comments

Dan Jesus · Accepted Answer · 2012-03-10 18:45:26Z

1

The fastest option and is more efficient:

SELECT * FROM posts WHERE post_id IN (14,15)

However using instructions OR is not wrong

SELECT * FROM posts WHERE post_id = 14 OR post_id = 15

edited Mar 10, 2012 at 18:45

user142162

answered Mar 10, 2012 at 1:52

Dan Jesus

1085 bronze badges

Comments

Cenius · Accepted Answer · 2012-01-11 15:27:34Z

0

Use OR / AND in where condition. Like:

SELECT * FROM posts WHERE post_id = '13' OR post_id = '14' OR post_id = '15'

answered Jan 11, 2012 at 15:27

Cenius

1031 gold badge1 silver badge9 bronze badges

Comments

Aurelio De Rosa · Accepted Answer · 2012-01-11 15:41:46Z

0

You could also use:

SELECT * FROM posts WHERE post_id BETWEEN 14 and 15

edited Jan 11, 2012 at 15:41

Aurelio De Rosa

22.2k8 gold badges51 silver badges71 bronze badges

answered Jan 11, 2012 at 15:30

Peter Larsen

5032 gold badges9 silver badges20 bronze badges

Collectives™ on Stack Overflow

mysql select query with multiple WHERE

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related