select query to get only todays date records

[reddymade]

I want to use the following query to show only users who registered today with todays date.format(m/d/y)
field name is: a.date_registration

select a.id, a.fname, a.sname, a.status, a.login, a.login_count, b.lang_1 as gender, a.email from pro_user a left join pro_reference_lang_spr b on b.table_key='12' and b.id_reference=a.gender where a.date_registration = (Todays Date m/d/y) order by a.login limit 0, 10 0, 10 

Thank you very much for the info.

[devinemke]

... WHERE a.date_registration = CURDATE() ...