How to obtain the next record based on products_id 6

How to obtain the previous record of products_id 6. How to obtain the previous record of products_id 6. Note that the products_id & lt; 6limit1 condition cannot be used, because products_id is a random arrangement of the size, select * fromttwhereproducts_id & lt; 6or how to retrieve the previous record based on products_id 6.
How to obtain the previous record of products_id 6.
Note that the products_id <6 limit 1 condition cannot be used, because products_id is a random array of sizes.


------ Solution --------------------
Select * from tt where products_id <6 order by products_id desc limit 1
------ Solution --------------------
Select * from tt where price. products_id <6 and price. price = '000000' order by price. products_id desc limit 1, try