How can I get first 100 values from database and next 100 and so on?
I have a simple database to store some emails, Is there any way to get the emails from the database in groups of a 100 emails ???
Here is the database structure
Table structure for table `emails` -- CREATE TABLE IF NOT EXISTS `emails` ( `email` varchar(100) NOT NULL, `ip` varchar(15) NOT NULL, `timestamp` datetime NOT NULL, PRIMARY KEY (`email`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
The ideal outcome would be to get the first 100 emails, do something and later get the next 100 and do something else.
Thanks and sorry for my english
Then for the next one, LIMIT 100, 100, and then LIMIT 200, 100, and so on.
The first number (when there are two) is the offset.