Mysql Query problems

Mysql Query problem select & nbsp; * & nbsp; from & nbsp; commodity & nbsp; WHERE & nbsp; name & nbsp; LIKE & nbsp; $ keywords & nbsp; ORDER & nbsp; BY & nbsp; rank & nbsp; $ rank & nbsp; limit & nbsp; $ pages, & nbsp; $ rowsWHERE, ORD mysql Query problems
Select * from commodity WHERE name LIKE $ keywords order by rank $ rank limit $ pages, $ rows


How should I arrange the WHERE, ORDER, and limit statements at the same time?


In this way, select * from commodity order by rank $ rank limit $ pages, $ rows

Share: More

------ Solution --------------------
Select * from tbname order by id desc limit 0, 10
------ Solution --------------------
Okay! That's the answer!