mysql:选择以 2012-02* 开头的所有字段

Question

如何选择mysql中以“2012-02”开头的所有字段？

我尝试过的:

mysql> SELECT title,id FROM dle_post WHERE approve='1' AND date = '2012-02-13 21:35:00';
+-------------------------------------------------+----+
| title                                           | id |
+-------------------------------------------------+----+
| test title                                      |  7 |
+-------------------------------------------------+----+


mysql> SELECT title,id FROM dle_post WHERE approve='1' AND date='2012-02%';
Empty set, 2 warnings (0.00 sec)

mysql> SHOW WARNINGS;
+---------+------+-----------------------------------------------------------------+
| Level   | Code | Message                                                         |
+---------+------+-----------------------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: '2012-02%' for column 'date' at row 1 |
| Warning | 1292 | Incorrect datetime value: '2012-02%' for column 'date' at row 1 |
+---------+------+-----------------------------------------------------------------+

Answer 1

理想情况下，日期应被视为日期，而不是字符串。此查询应返回 2012 年 2 月的所有行，并且其性能应优于 LIKE % 查询:

SELECT title, id
FROM dle_post
WHERE approve = 1 
AND date >= '2012-02-01' 
AND date <  '2012-02-01' + INTERVAL 1 MONTH