> 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
> Does anyone know if there is a way of setting an auto numbered field
> that starts at say 2,000,000 and decreases by one on each insert?
Well, if you know the starting number you can use a normal autoinc field and
retrieve the value you want by substracting:
2,000,000 - AutoIncField
Regards
