CREATE TABLE `animals` (
  `id` mediumint( 9 ) NOT NULL auto_increment,
  `name` char( 30 ) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

insert into animals (name) values ( "Cat" );
insert into animals (name) values ( "Dog" );
insert into animals (name) values ( "Lion" );
insert into animals (name) values ( "Tiger" );
insert into animals (name) values ( "Elephant" );

select * from animals;
+ ----+----------+
 
| id | name     |
+ ----+----------+
 
|   1  | Cat      |
|   2  | Dog      |
|   3  | Lion     |
|   4  | Tiger    |
|   5  | Elephant |
+ ----+----------+
 
 5  rows in set ( 0 . 00  sec)

select * from animals order by rand() limit  1 , 1 ;
+ ----+------+
 
| id | name |
+ ----+------+
 
|   2  | Dog  |
+ ----+------+
 
 1  row in set ( 0 . 01  sec)

select * from animals order by rand() limit  1 , 1 ;
+ ----+-------+
 
| id | name  |
+ ----+-------+
 
|   4  | Tiger |
+ ----+-------+
 
 1  row in set ( 0 . 00  sec)

select * from animals order by rand();
+ ----+----------+
 
| id | name     |
+ ----+----------+
 
|   2  | Dog      |
|   3  | Lion     |
|   1  | Cat      |
|   4  | Tiger    |
|   5  | Elephant |
+ ----+----------+
 
 5  rows in set ( 0 . 01  sec)

select * from animals order by rand();
+ ----+----------+
 
| id | name     |
+ ----+----------+
 
|   5  | Elephant |
|   4  | Tiger    |
|   3  | Lion     |
|   2  | Dog      |
|   1  | Cat      |
+ ----+----------+
 
 5  rows in set ( 0 . 00  sec)

select version();
+ ------------+
 
| version()  |
+ ------------+
 
|  3 . 23 . 52 -nt |
+ ------------+
 
 1  row in set ( 0 . 00  sec)