MySQL select range IN

Question

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

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

Instead

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

Answer 1

You cannot, but you can use BETWEEN

 SELECT job FROM mytable WHERE id BETWEEN 10 AND 15 

Please note that BETWEEN is inclusive and will contain elements with identifiers 10 and 15.

If you do not want to include, you will have to revert to using the > and < operators.

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

Answer 2

To select data in a numerical range, you can use BETWEEN , which is included.

 SELECT JOB FROM MYTABLE WHERE ID BETWEEN 10 AND 15;