SELECT query with initial id?

Question

MySQL

There is a table with fields: id INT, name VARCHAR(255), date DATE.
How can I form a SELECT query sorted by the date field so that records start with a fixed id value?
Let me explain.
the entire table is sorted by date, while the id can go as you like, for example like this: 10, 20, 3, 40, 15, 1, 17. I need to get a bunch of rows with a query (LIMIT 10 for example), but so that each pack starts with a specific id. For example, you need with id=40, then there will be a sequence: 40, 15, 1, 17, etc.

Answer 1

If all dates in the table are unique, then the following query will do
: select * from tbl
where `date` >= (select `date` from tbl where id = 40)
order by `date`;

Answer 2

where will work just fine under these conditions:

select id,name,"DATE" from your_table order by "DATE",id,name where id>=N

Answer 3

You can try to do it with a subquery that will select by date, and the main query will filter id
But something tells me that you initially have something wrong with the architecture

Answer 4

Zprros
and
Absolutely identical in terms of the set of records that will be returned. Only the sorting of records will be changed. But records and there and there tezhe.
You need to understand that ORDER BY does not depend on WHERE. You can just do
AND again get the same records just not sorted.

Answer 5

Then so.

select * from tbl b
where b.date>= (select a.date from (select date from tbl
where id = 40
order by date) a
limit 1)
order by b.date;

But only if the combination of ID and DATE is unique.