php - 我想要选择数据，但它不起作用

Question

我有一张 table :

 CREATE TABLE IF NOT EXISTS `ccu_log` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `ccu` int(10) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5626 ;

--
-- Dumping data for table `ccu_log`
--

INSERT INTO `ccu_log` (`id`, `ccu`, `time`, `date`) VALUES
(1, 0, '22:27:30', '2015-01-08'),
(2, 0, '22:29:01', '2015-01-08'),
(3, 0, '22:30:31', '2015-01-08'),
(4, 0, '22:32:01', '2015-01-08'),
(5, 3, '22:33:31', '2015-01-08'),
(6, 0, '22:35:01', '2015-01-08'),
(7, 4, '22:36:31', '2015-01-08'),
(8, 8, '22:38:01', '2015-01-09'),
(9, 5, '22:39:31', '2015-01-09'),
(10, 1, '22:41:01', '2015-01-09');

当我想用 mysql 查询选择数据时:

SELECT * 
FROM `ccu_log` 
WHERE UNIX_TIMESTAMP("date") = UNIX_TIMESTAMP('09-01-2015')

它显示我表中的所有行。如果我用户查询:

SELECT * FROM `ccu_log` where UNIX_TIMESTAMP(date) = UNIX_TIMESTAMP('09-01-2015')

它没有返回预期的结果。

有什么建议吗？

Answer 1

当字段已经是date类型时，您甚至不需要转换为时间戳来进行比较。就这么做

SELECT * FROM `ccu_log` WHERE `date`='2015-01-09'