mysql比較時間大小unix_timestamp，mysqlunixtimestamp

mysql比較時間大小unix_timestamp，mysqlunixtimestamp

使用unix_timestamp方法進行比較，將字符型的時間，轉成unix時間戳

select * from t1 where unix_timestamp(time1) > unix_timestamp('2011-03-03 17:39:05') and unix_timestamp(含有時間的字段) < unix_timestamp('2016-12-06');