CREATE TABLE `media` (
	`mid` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Registered media identifier',
	`event` DATETIME NOT NULL COMMENT 'Date and time the media was recorded',
	`type` ENUM('jpg','webm') NOT NULL COMMENT 'Media type',
	`bfn` CHAR(17) NOT NULL COMMENT 'Media base file name',
	`access` INT(10) UNSIGNED NOT NULL COMMENT 'Exclusive uid access',
	PRIMARY KEY (`mid`),
	UNIQUE INDEX `uniqueness` (`event`, `bfn`)
);

SELECT DISTINCT DAYOFMONTH(event) AS regdays FROM media WHERE (event>='2003-10-01') AND (event<=LAST_DAY('2003-10-01'));

SELECT * FROM media WHERE (event>="2003-10-8") AND (event<DATE_ADD("2003-10-8",INTERVAL 1 DAY));

id; select_type ;table; type  ;possible_keys; key       ; key_len; ref; rows; Extra
1 ; SIMPLE      ;media; range ;uniqueness   ; uniqueness; 8      ; \N;  63  ; Using where

SELECT * FROM media WHERE (event>="2004-4-16") AND (event<DATE_ADD("2004-4-16",INTERVAL 1 DAY));

id; select_type; table; type; possible_keys; key; key_len; ref; rows; Extra
1 ; SIMPLE;      media; ALL;  uniqueness;    \N;  \N;      \N;  576;  Using where