Anthony,
Here's the full definition of select statement:
SELECT [STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
[FROM table_references
[WHERE where_definition]
[GROUP BY {unsigned_integer | col_name | formula} [ASC | DESC], ...
[HAVING where_definition]
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
[LIMIT [offset,] rows]
[PROCEDURE procedure_name]
[FOR UPDATE | LOCK IN SHARE MODE]]
So,
LIMIT 10 ... means first 10 rows (or LIMIT 0, 10)
LIMIT 10, 10 ... means next 10 rows
LIMIT 20, 10 ... means ... etc
Best wishes,
Paul Najman [EMAIL PROTECTED]
----- Original Message -----
From: "Anthony Ward" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 2003 6:21 PM
Subject: Row Number
> Hi,
>
> If i have a table with just "Userid,Name,Language"
> where userid is primary key.
> now if i search the first 10 people that speaks english i.e
> SELECT * FROM tablex WHERE language='English' LIMIT 10;
>
> Can't i get the row number of the last matched record?
> So i can do
> SELECT...........LIMIT nex-ten-starting,10
>
> Regards,
> Anthony W.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
