MySQL query question

Question

Is there a way I can tell my MySQL query to start from a specific id and end at another using MySQL?

Answer 1

Using between operator you can achieve what you want.

syntax:

SELECT * FROM your_table_name WHERE id BETWEEN 'x' AND 'y'

Answer 2

use where id between x and y

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_between

update according to the remark

one option : where id =x or id = y . second option : where id in (x,y)