MySQL 选择 IN 范围

是否可以为查询的 IN 部分定义一个范围，如下所示

SELECT job FROM mytable WHERE id IN (10..15);

而不是

SELECT job FROM mytable WHERE id IN (10,11,12,13,14,15);

135629 次浏览

小开

最佳答案

You can't, but you can use BETWEEN

SELECT job FROM mytable WHERE id BETWEEN 10 AND 15

Note that BETWEEN is inclusive, and will include items with both id 10 and 15.

If you do not want inclusion, you'll have to fall back to using the > and < operators.

SELECT job FROM mytable WHERE id > 10 AND id < 15

小开

To select data in numerical range you can use BETWEEN which is inclusive.

SELECT JOB FROM MYTABLE WHERE ID BETWEEN 10 AND 15;