Mysql queries the previous and next records on the current data

Gets the current file on the same principle as the next record is the SQL statement, from the news table in order to select a smaller than the current ID of the news, the next SQL statement, from the news table in order to select a larger than the current ID of the news.

If the ID is a primary key or has an index, you can find it directly:

Method 1:

[SQL]View PlainCopy

2. 1.select * from table_a where id =  (select id  From table_a where id < {$id}  Order by id desc limit 1);    
4. 2.SELECT * from table_a where id = (select id from table_a where ID > {$id} ORDER by ID  ASC limit 1);

Method 2:

[SQL]View PlainCopy

1. 1.select * from table_a where id = (select max (ID) from table_a where ID < {$id});
2. 2.SELECT * from table_a where id = (Theselect min (id) from table_a where ID > {$id});

Mysql queries the previous and next records on the current data