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_number` int(10) unsigned 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.05 sec)

mysql> 
mysql> ALTER TABLE test1 ADD INDEX idx_load_time(load_time);
Query OK, 0 rows affected (0.03 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_number, load_time )
    -> VALUES ( 1, '2006-12-04 00:00:01' ),
    ->        ( 2, '2006-12-04 00:00:02' ),
    ->        ( 3, '2006-12-04 00:00:03' ),
    ->        ( 4, '2006-12-04 00:00:04' ),
    ->        ( 5, '2006-12-04 00:00:05' ),
    ->        ( 6, '2006-12-04 00:00:06' ),
    ->        ( 7, '2006-12-04 00:00:07' ),
    ->        ( 8, '2006-12-04 00:00:08' ),
    ->        ( 9, '2006-12-04 00:00:09' ),
    ->        ( 10, '2006-12-04 00:00:10' ),
    ->        ( 11, '2006-12-04 00:00:10' ),
    ->        ( 12, '2006-12-04 00:00:10' ),
    ->        ( 13, '2006-12-04 00:00:10' ),
    ->        ( 14, '2006-12-04 00:00:10' ),
    ->        ( 15, '2006-12-04 00:00:10' ),
    ->        ( 16, '2006-12-04 00:00:10' ),
    ->        ( 17, '2006-12-04 00:00:10' ),
    ->        ( 18, '2006-12-04 00:00:10' ),
    ->        ( 19, '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_number | load_time           |
+-------------+---------------------+
|           1 | 2006-12-04 00:00:01 |
|           2 | 2006-12-04 00:00:02 |
|           3 | 2006-12-04 00:00:03 |
|           4 | 2006-12-04 00:00:04 |
|           5 | 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_number | load_time           |
+-------------+---------------------+
|           6 | 2006-12-04 00:00:06 |
|           7 | 2006-12-04 00:00:07 |
|           8 | 2006-12-04 00:00:08 |
|           9 | 2006-12-04 00:00:09 |
|          10 | 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_number | load_time           |
+-------------+---------------------+
|          11 | 2006-12-04 00:00:10 |
|          12 | 2006-12-04 00:00:10 |
|          13 | 2006-12-04 00:00:10 |
|          14 | 2006-12-04 00:00:10 |
|          15 | 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_number | load_time           |
+-------------+---------------------+
|          12 | 2006-12-04 00:00:10 |
|          11 | 2006-12-04 00:00:10 |
|          10 | 2006-12-04 00:00:10 |
|          19 | 2006-12-04 00:00:10 |
+-------------+---------------------+
4 rows in set (0.00 sec)

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