您可以使用MysqL的STR_TO_DATE()
功能
SELECT id, date
FROM tableName
WHERE STR_TO_DATE(date,'%Y-%m-%d') >= '01/01/2012'
ORDER BY date DESC;
尽管我怀疑您使用Unix时间戳会更轻松
SELECT id, date聽
FROM tableName聽
WHERE UNIX_TIMESTAMP(STR_TO_DATE(date,'%d/%m/%Y')) >= UNIX_TIMESTAMP('01/01/2012')聽
ORDER BY date DESC;