Select Query

[reddymade]

I am using the following query, but it does'nt bring any users records who registered today.
a.date_registration = CURDATE()

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 = CURDATE() order by a.login limit 0, 10 

Can you please tell me what is wrong in the above query.

Thank you very much for the info.

[devinemke]

what RDBMS are you using?
what field type is a.date_registration?

[reddymade]

Type is Datetime for field date_registration

using mysql

Thank you.

[devinemke]

reddymade wrote:

Type is Datetime for field date_registration

then change your query to:

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