There is a table news. You need to select 10 entries, starting with 4 on the list, but not on the id. How can this be done?
SELECT * FROM news LIMIT 10 ... ? 
|
2 answers
SELECT * FROM news ORDER BY YOUR_FIELD_NAME LIMIT 4, 10 Alexey Shimansky Alexey Shimansky
37k 5 gold signs 48 silver marks 115 bronze marks
|
Order by the required field on which we limit limit 4,10
Order by sorts and limit then truncates 10 entries starting from 4th
Pobezhimov Boris Pobezhimov Boris
1.548 4 silver marks 20 bronze marks
|