mySQL select IN range

up vote 10 down vote favorite 3	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); mysql shareimprove this question edited Oct 18 '14 at 18:53 offby1 3,6601126 asked May 14 '12 at 15:08 Owen 1,41163056
	add a comment

1 Answer

active oldest votes

up vote 28 down vote accepted

You can't, but you can use BETWEEN SELECT job FROM mytable WHERE id BETWEEN 10 AND 15 shareimprove this answer