CREATE TABLE `daily` ( `uid` bigint(10) unsigned NOT NULL auto_increment, `memberID` bigint(10) unsigned NOT NULL default '0', `date` date NOT NULL default '0000-00-00', `created` datetime NOT NULL, `mood` smallint(6) NOT NULL default '0', `text` text NOT NULL, `private` set('no','hot','me','adult') NOT NULL default 'no', `good` int(10) unsigned NOT NULL default '0', `view` int(10) unsigned NOT NULL default '0', `checkcode` varchar(32) NOT NULL default '', `Notify` enum('y','n') NOT NULL default 'n', `modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `attrib` enum('user','gold','free') NOT NULL default 'user', PRIMARY KEY (`uid`), UNIQUE KEY `memberID_2` (`memberID`,`date`), KEY `date` (`date`,`private`,`uid`), KEY `diaryLast` (`memberID`,`created`) ) DEFAULT CHARSET=utf8; SELECT MIN(date) FROM daily WHERE memberID='8014' AND date>'2007-08-01';