netripper

CREATE TABLE IF NOT EXISTS `log` (
  `idx` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `when` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `how` VARCHAR(50) NOT NULL DEFAULT '',
  `where` VARCHAR(50) NOT NULL DEFAULT '',
  `who` VARCHAR(50) NOT NULL DEFAULT '',
  `what` text NOT NULL,
  PRIMARY KEY  (`idx`),
  KEY `where` (`where`),
  KEY `who` (`who`),
  KEY `how` (`how`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1255578 ;


-- deze query duurt 6.58 sec
SELECT DATE(`when`) FROM log WHERE `where` LIKE '#htc-linux' ORDER BY `when` DESC LIMIT 1;