sql - Multiple OR Clauses in MySQL

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

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)"

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

1 Answer

深蓝 · Answer 1 · 2021-10-17T02:57:59+0000

answered Oct 17, 2021 by 深蓝 (71.8m points)

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

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…