There are two SQL statements. One is
select count(*) from steventable where username='steven';
select * from steventable where username='steven' LIMIT 0 , 30;
Is it possible to combine two SQL statements into one? The first one is to get how many records in steventable when username is steven, the second one is to fetch the first 30 records which username is steven.
I am using MySQL.