mySQL select IN range

Question

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     Instead of   SELECT job FROM mytable WHERE id IN  10 11 12 13 14 15

User · Accepted Answer

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  gt  and  lt  operators   SELECT job FROM mytable WHERE id  gt  10 AND id  lt  15

User · Answer

To select data in numerical range you can use BETWEEN which is inclusive   SELECT JOB FROM MYTABLE WHERE ID BETWEEN 10 AND 15

[mysql] mySQL select IN range

Examples related to mysql