SQL LIMIT question

jormajansson

Is it possible to make sql-clause (in mysql) where one parameter of LIMIT is select-clause to same table ?

Like this:
SELECT FROM PERSONAL ORDER BY NAME LIMIT
(SELECT FROM PERSONAL WHERE ID=770),10

I try to list next ten rows after the record that ID is 770 and
order the list by name, so that record id=770 is first.

bad76

Originally posted by jormajansson
Is it possible to make sql-clause (in mysql) where one parameter of LIMIT is select-clause to same table ?

Like this:
SELECT FROM PERSONAL ORDER BY NAME LIMIT
(SELECT FROM PERSONAL WHERE ID=770),10

I try to list next ten rows after the record that ID is 770 and
order the list by name, so that record id=770 is first.

Hi,
change your point of view:

you have to get first ten rows WHERE ID>770...

Is it more easy now?

jormajansson

you have to get first ten rows WHERE ID>770...

when I insert a new record Name = 'Bush' , new record's ID field (autoincrement) gets the biggest ID of table.

And after inserting, I need to get just inserted record to first record and nine next record order by name.

Record where name = 'Bush' is in the beginning of table (order by name) but ID filed is largest.

I use table all time "order by name"

bad76

It's the same.
Try to use something like this:

select Name, STRCMP(Name,'Bush') as sorting
from this_table

having sorting>=0
order by Name
limit 0,10

You have just to setup STRCMP to get what you want
(i tested first three are wrong 😕 )

see you