sql - 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, ...)