php - 选择两个日期之间的数据？

Question

我正在使用一个数据库来存储日志，其中有一列“日期”保存了它被插入的日期。日期格式为“MM/DD/YY”。请任何人建议我如何在两个特定日期之间选择数据。例如，我试过这个:

$from_date = "01/01/12";
$to_date = "02/11/12";

$result = mysql_query("SELECT * FROM logs WHERE date >= " . $from_date . " AND date <= " . $to_date . " ORDER by id DESC");

while($row = mysql_fetch_array($result)) {
// display results here
}

但我猜这行不通，因为日期不是数字。谢谢您的帮助! :)

Answer 1

使用 BETWEEN 关键字:

"SELECT * FROM logs WHERE date BETWEEN '" . $from_date . "' AND  '" . $to_date . "'
ORDER by id DESC"