here’s another approach, which fully incorporates the basic requirement and at the same time makes use of an index (which should exist) on the column…
WHERE dateregister >= CURRENT_DATE
AND dateregister < CURRENT_DATE + INTERVAL 1 DAYworks regardless of whether dateregister is DATE or DATETIME dataype
I’m confused. How does that get what he wants? Yours returns where the dateregister falls onto today. I read the OP as the user is looking almost for a trend query. So, if the user has 30 Sept., show all registrations for that date regardless of year (so 30 Sept. '14, 30 Sept. '12, etc.)