Developer's Note@Wiki
MySQL
最終更新：
handsrecs
-
view
MySQL
昨日のデータを取得
1.より2.の方が断然早い
1. カラムのデータをdate型に変換
select * from accesses where date(created) = date(current_date()-1)
2. 範囲指定(昨日～本日)
select * from accesses where created >= date(current_date()-1) and created < date(current_date())
