mySQL query for multiple attributes

Question

Is there a way to run this query to match all of these numbers without running the query 5 times? and if this is possible, how do I query these numbers if they're in a php array?

Numbers: 1, 26, 44, 45, 13

Query String:

SELECT ky, project_name FROM project WHERE ky = 1 OR 26 OR 44 OR 45 OR 13;

Rogue · Accepted Answer · 2013-11-21 16:08:09Z

2

Two ways

/* ... */ WHERE ky = 1 OR ky = 26 OR /* ... */

Or you could use IN

/* ... */ WHERE ky IN (1, 26, /* etc */)

answered Nov 21, 2013 at 16:08

Rogue

11.5k6 gold badges51 silver badges74 bronze badges

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

Comments

Ghazanfar Mir · Accepted Answer · 2013-11-21 16:10:36Z

0

Use IN keyword which is equallent to ORs

SELECT ky, project_name FROM project WHERE ky IN ( 1, 26, 44, 45, 13);

answered Nov 21, 2013 at 16:10

Ghazanfar Mir

3,5412 gold badges28 silver badges42 bronze badges

Collectives™ on Stack Overflow

mySQL query for multiple attributes

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related