mysql - Query to get registrations that happen within NOW and 1 MINUTE ago -

i trying set query return user ids of registrations happened in last minute (between , last minute).

so far trying this:

select member_id  members  registration_date  between date( date_sub( now() , interval 1 minute ) ) , date ( now() ) 

but don't think working. not returning records. can point me in right direction?

the registration column on form:

y-m-d h:i:s 

please appreciated.

thank you!

don't call date(), since that's removing time of day values.

select member_id  members  registration_date  between date_sub(now(), interval 1 minute) , now()