MySQL选择IN范围 [英] mySQL select IN range

问题描述

是否可以为查询的IN部分定义一个范围，就像这样

Is it possible to define a range for the IN part of the query, something like this

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

代替

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

推荐答案

您不能，但是可以使用BETWEEN

You can't, but you can use BETWEEN

SELECT job FROM mytable WHERE id BETWEEN 10 AND 15

请注意，BETWEEN是包含性的，将包含ID为10和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

这篇关于MySQL选择IN范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！