Here ya go....my table structure is -

mysql> describe joke;
+----------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| joketext | text | YES | | NULL | |
| jokedate | date | NO | | NULL | |
+----------+---------+------+-----+---------+----------------+
3 rows in set (0.02 sec)