0
3
Mitul Dabhi
answered Nov 30 '-1 00:00
you can use subdate(CURRENT_DATE, 1)
subdate means it minus date from the given date . CURRENT_DATE is constant of MySQL for current date. and we are passing 1 as second argument so it will minus 1 day from current date and it give us yesterday date , it return yyyy-mm-dd
select * from users where register_date = subdate(CURRENT_DATE, 1)
should work but you have register_date is dateTime Field type so you should convert register_date to date by DATE function of MySQL
so it will be
select * from users where DATE(register_date)= subdate(CURRENT_DATE, 1)
3
Mahesh Radadiya
answered Nov 30 '-1 00:00
you can use DATEDIFF function also
SELECT * FROM `users` where DATEDIFF(register_date,CURRENT_DATE)=-1
=-1 because it give minus value for yesterday - today
or
SELECT * FROM `users` where DATEDIFF(CURRENT_DATE,register_date)=1
=1 because it give minus value for today - yesterday
2
ravi
answered Nov 30 '-1 00:00
CURRENT_DATE()-1 = yesterdady
use it like this
select * from users where DATE(register_date)=CURRENT_DATE()-1
2
shyam
answered Nov 30 '-1 00:00
you can add your date + 1 day and match it with current date
select * from `users` where DATE(register_date)+1 =CURRENT_DATE()
or you can use interval to subtract 1 day from current date.
SELECT * FROM `users` where DATE(register_date)=CURRENT_DATE - INTERVAL 1 DAY