mysql> --<BEGIN CODE>
mysql> USE test;
Database changed
mysql> 
mysql> DROP TABLE `test1`;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> CREATE TABLE `test1` (
    ->  `test_case` varchar(64) NOT NULL,
    ->  `load_time` datetime NOT NULL default '0000-00-00 00:00:00'
    -> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.19 sec)

mysql> 
mysql> ALTER TABLE test1 ADD INDEX idx_load_time(load_time);
Query OK, 0 rows affected (0.09 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> 
mysql> TRUNCATE TABLE test1;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> INSERT INTO test1 ( test_case, load_time )
    -> VALUES ( 'a', '2006-12-04 00:00:01' ),
    ->        ( 'b', '2006-12-04 00:00:02' ),
    ->        ( 'd', '2006-12-04 00:00:03' ),
    ->        ( 'b', '2006-12-04 00:00:04' ),
    ->        ( 'a', '2006-12-04 00:00:05' ),
    ->        ( 'f', '2006-12-04 00:00:06' ),
    ->        ( 'g', '2006-12-04 00:00:07' ),
    ->        ( 'g', '2006-12-04 00:00:08' ),
    ->        ( 'i', '2006-12-04 00:00:09' ),
    ->        ( 'a', '2006-12-04 00:00:10' ),
    ->        ( 'c', '2006-12-04 00:00:10' ),
    ->        ( 'd', '2006-12-04 00:00:10' ),
    ->        ( 'q', '2006-12-04 00:00:10' ),
    ->        ( 'r', '2006-12-04 00:00:10' ),
    ->        ( 's', '2006-12-04 00:00:10' ),
    ->        ( 't', '2006-12-04 00:00:10' ),
    ->        ( 'u', '2006-12-04 00:00:10' ),
    ->        ( 'v', '2006-12-04 00:00:10' ),
    ->        ( 'v', '2006-12-04 00:00:10' );
Query OK, 19 rows affected (0.00 sec)
Records: 19  Duplicates: 0  Warnings: 0

mysql> 
mysql> SELECT * FROM test1
    -> WHERE load_time > 0
    -> ORDER BY load_time
    -> LIMIT 0,5;
+-----------+---------------------+
| test_case | load_time           |
+-----------+---------------------+
| a         | 2006-12-04 00:00:01 |
| b         | 2006-12-04 00:00:02 |
| d         | 2006-12-04 00:00:03 |
| b         | 2006-12-04 00:00:04 |
| a         | 2006-12-04 00:00:05 |
+-----------+---------------------+
5 rows in set (0.00 sec)

mysql> 
mysql> SELECT * FROM test1
    -> WHERE load_time > 0
    -> ORDER BY load_time
    -> LIMIT 5,5;
+-----------+---------------------+
| test_case | load_time           |
+-----------+---------------------+
| f         | 2006-12-04 00:00:06 |
| g         | 2006-12-04 00:00:07 |
| g         | 2006-12-04 00:00:08 |
| i         | 2006-12-04 00:00:09 |
| a         | 2006-12-04 00:00:10 |
+-----------+---------------------+
5 rows in set (0.00 sec)

mysql> 
mysql> SELECT * FROM test1
    -> WHERE load_time > 0
    -> ORDER BY load_time
    -> LIMIT 10,5;
+-----------+---------------------+
| test_case | load_time           |
+-----------+---------------------+
| c         | 2006-12-04 00:00:10 |
| d         | 2006-12-04 00:00:10 |
| q         | 2006-12-04 00:00:10 |
| r         | 2006-12-04 00:00:10 |
| s         | 2006-12-04 00:00:10 |
+-----------+---------------------+
5 rows in set (0.00 sec)

mysql> 
mysql> SELECT * FROM test1
    -> WHERE load_time > 0
    -> ORDER BY load_time
    -> LIMIT 15,5;
+-----------+---------------------+
| test_case | load_time           |
+-----------+---------------------+
| d         | 2006-12-04 00:00:10 |
| c         | 2006-12-04 00:00:10 |
| a         | 2006-12-04 00:00:10 |
| v         | 2006-12-04 00:00:10 |
+-----------+---------------------+
4 rows in set (0.00 sec)

mysql> --<END CODE>
mysql> \t