mysql datatime index 처리하기

regdate between date_format(now() - interval 1 day, '%Y-%m-%d 00:00:00') 

                  and date_format(now() - interval 1 day, '%Y-%m-%d 23:59:59')