查询语句中的IN部分是否可以定义一个范围,类似于这样
SELECT job FROM mytable WHERE id IN (10..15);
代替原来的SELECT job FROM mytable WHERE id IN (10,11,12,13,14,15);
查询语句中的IN部分是否可以定义一个范围,类似于这样
SELECT job FROM mytable WHERE id IN (10..15);
代替原来的SELECT job FROM mytable WHERE id IN (10,11,12,13,14,15);
你不能这样做,但是你可以使用 BETWEEN
。
SELECT job FROM mytable WHERE id BETWEEN 10 AND 15
请注意,BETWEEN
是包容性的,会包括id为10和15的项。
如果您不想包含它们,必须使用>
和<
运算符。
SELECT job FROM mytable WHERE id > 10 AND id < 15
BETWEEN
。SELECT JOB FROM MYTABLE WHERE ID BETWEEN 10 AND 15;