Pagination in MySQL

Select * from tips order by tip_no limit 25,4;

where 25 is the start row of the record fetched and 4 is the number of records to be fetched.