我有以下查询:
SELECT id,name
FROM categ
WHERE email_activated='1'
ORDER BY id DESC
但我只想查询 ID 3、4、5 和 1。
如何在查询中指定这些 ID?
使用 IN 子句
SELECT id, name
FROM categ
WHERE email_activated='1'
AND id IN (1, 3, 4, 5)
ORDER BY id DESC
参考: http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_in