SQL/MySQL/Math/Random

Random row from the table

   <source lang="sql">

/* mysql> Drop table timeTable; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TABLE timeTable (

   ->     year YEAR(4),
   ->     month INT(2) UNSIGNED ZEROFILL,
   ->     day INT(2) UNSIGNED ZEROFILL
   -> );

Query OK, 0 rows affected (0.08 sec) mysql> INSERT INTO timeTable VALUES(2001,1,1),

   ->                             (2002,6,20),
   ->                             (2003,5,30),
   ->                             (2004,2,2),
   ->                             (2005,4,23),
   ->                             (2006,3,23);

Query OK, 6 rows affected (0.00 sec) Records: 6 Duplicates: 0 Warnings: 0 mysql> select * from timeTable; +------+-------+------+ | year | month | day | +------+-------+------+ | 2001 | 01 | 01 | | 2002 | 06 | 20 | | 2003 | 05 | 30 | | 2004 | 02 | 02 | | 2005 | 04 | 23 | | 2006 | 03 | 23 | +------+-------+------+ 6 rows in set (0.01 sec) mysql> SELECT * FROM timeTable ORDER BY RAND() LIMIT 3; +------+-------+------+ | year | month | day | +------+-------+------+ | 2002 | 06 | 20 | | 2005 | 04 | 23 | | 2001 | 01 | 01 | +------+-------+------+ 3 rows in set (0.00 sec)

• /

Drop table timeTable; CREATE TABLE timeTable (

   year YEAR(4), 
   month INT(2) UNSIGNED ZEROFILL,
   day INT(2) UNSIGNED ZEROFILL

); INSERT INTO timeTable VALUES(2001,1,1),

                           (2002,6,20),
                           (2003,5,30),
                           (2004,2,2),
                           (2005,4,23),
                           (2006,3,23);

select * from timeTable;

SELECT * FROM timeTable ORDER BY RAND() LIMIT 3;

      </source>