Multiple OR Clauses in MySQL

Question

I'm trying to grab content where id = 3 OR id = 9 OR id = 100... Keep in mind, I can have a few hundred of these ids.

What is the most efficient way to write my query?

$sql = "SELECT name FROM artists WHERE (id=3 OR id=9 OR .... id-100)"

Answer 1

  ....
WHERE id IN (3, 9, 100, ...)

Answer 2

$sql = "SELECT name FROM artists WHERE id REGEXP regex-pattern"

Answer 3

SELECT * FROM table WHERE id IN (1, 2, 3 etc)

And call only the columns you need rather than using *!

Answer 4

You may want to use the IN() function:

... WHERE id IN (3, 9, 100);

The IN() function syntax:

expr IN (value,...)

Check whether a value is within a set of values ...

Returns 1 if expr is equal to any of the values in the IN list, else returns 0.

Answer 5

You can use SQL IN condition

SELECT * FROM table WHERE ID IN ('1', '2', '3', '4');

Answer 6

SELECT * FROM table WHERE id IN (1,2,5);

Answer 7

SELECT * FROM table WHERE id IN (1,2,5)