php - 检查列中的某些数据

Question

是否可以检查列中的特定数据？例如，我有一个名为 'added' 的列，值类似于 '2011-04-18 10:44:42'

并且可以仅从列中检查日期 '2011-04-18'

$date = sqlesc(get_date_time());
$res = mysql_query("SELECT id, username FROM users WHERE added = 
        $date ORDER BY username") or print(mysql_error());

Answer 1

SELECT  id, username
FROM    users
WHERE   added >= '2011-04-18'
        AND added < '2011-04-18' + INTERVAL 1 DAY