[Solved] how to split mysql query condition

SELECT * FROM table WHERE DATE(Registration Date and Time) = '2020-06-24'

DATE type format is YYYY-MM-DD

check this link out as well, I think this is what you are looking for.