MySQL

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())