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?

Haim Evgi · Accepted Answer · 2010-08-19 08:04:51Z

1

use where id between x and y

update according to the remark

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

answered Aug 19, 2010 at 7:58

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

what if I just want what those two ids are related too and nothing else.

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

Murali · Accepted Answer · 2019-04-22 19:54:31Z

0

Using between operator you can achieve what you want.

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

answered Apr 22, 2019 at 19:54

Murali

356 bronze badges