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

Answers


LIMIT 100

http://dev.mysql.com/doc/refman/5.1/en/select.html#id827984

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.


Need Your Help

SSL applying to too many domains

apache ssl openssl

I am having a problem with OpenSSL. I am on an apache server, which I am using to deal with SSL. I am only directing it to apply SSL to one domain, but it seems to be doing a blanket apply.

How to compile the c++ source files, generated in run-time, using waf?

c++ waf

I have protobuf proto-files in source tree. I want to generate the source files from proto-files on every change and on first run (e.g. I create new proto-file). Then, I want to compile shared libr...