i have table name login_master and one field in there is "date_of_ev ent"
example value date_Of_Event Jun 7, 2006 3:31:10 AM

Jun 7, 2006 to Jun 11, 2006 (I don't need time),how to write MySQL command?

pls help me

with regards,
rajesh