MySQL: select row numbers

[Disco]

Hi,

I would like to be able to do something like this...

select name,dob from employees where [rownum] > 10 and [rownum] < 20;

.... results from this would show me data from the 10th, 11th,... and 19th
row.

is this an option?
Thanks

[Good Man]

"Disco" <di**********@yahoo.com> wrote in news:oEuTa.140$0h6.10237
@nnrp1.ozemail.com.au:

Hi,

I would like to be able to do something like this...

select name,dob from employees where [rownum] > 10 and [rownum] < 20;

... results from this would show me data from the 10th, 11th,... and 19th
row.

is this an option?

try it!

[2metre]

select name,dob from employees
order by name
LIMIT 10,20

"Disco" <di**********@yahoo.com> wrote in message
news:oE*****************@nnrp1.ozemail.com.au...

Hi,

I would like to be able to do something like this...

select name,dob from employees where [rownum] > 10 and [rownum] < 20;

... results from this would show me data from the 10th, 11th,... and 19th
row.

is this an option?
Thanks

[Miron]

select name,dob from employees where ID >= 10 AND <= 20
ID in this case is the automatically incremented row id. I always use one!
HTH

"Disco" <di**********@yahoo.com> wrote in message
news:oE*****************@nnrp1.ozemail.com.au...

Hi,

I would like to be able to do something like this...

select name,dob from employees where [rownum] > 10 and [rownum] < 20;

... results from this would show me data from the 10th, 11th,... and 19th
row.

is this an option?
Thanks