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 |
Wouldn't you just type SELECT.LIMIT 10,10 ??
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 11:21 AM
To: [EMAIL PROTECTED]
Subject: Row Number
Hi,
If i have a table with just "Userid,Name,Language"
> 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...LIM
