mysql numrow

[lleemon]

In Oracle you can do the following and only return the first 5 records:
select *
from tablename
where rownum = 5;

Does anyone know if you can do the same thing in MySql? I have heard of a numrow but was unable to find this on the MySql site. If anyone can send me a sample of how to do this I would be very greatful.

Thanks in advance.

 

[piti]

in mysql there's the LIMIT keyword for this:

select * from table LIMIT 5

 

[KarveR]

or in mySQL you can select some of the records using LIMIT 10,20 which gives record 10 thru record 20 inclusive. ***************************************
Party on, dudes!