Is there possibility to first LIMIT and then ORDER records?
Not with a single SELECT. ORDER BY occurs before LIMIT.
You could use LIMIT and select into a temporary table, then select from the temporary table with ORDER BY.
Using simple query I can first ORDER and then LIMIT like that:
SELECT id, name FROM table ORDER BY name LIMIT 20,10
Maybe should I use procedures ?
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]