How to get only date from DATETIME mysql?

Question

MySQL

Hello, please tell me, something is not working the request, I need to get the date without time from the database and compare it with the current date on the server, I make the following request

SELECT DATE(`registration_date`) FROM  `class_users`  WHERE  `registration_date` =  '2020-02-26' AND  `id` =  '7260'

however, it returns an empty result, the registration_date field is in datetime format,

although it should accurately display only 1 result in which both id and registration_date match,

please tell me how else you can try

Answer 1

SELECT DATE(`registration_date`) FROM  `class_users`  
WHERE DATE(`registration_date`) =  '2020-02-26' AND  `id` =  '7260'

SELECT DATE(`registration_date`) FROM  `class_users`  
WHERE `registration_date` LIKE '2020-02-26%' AND  `id` =  '7260'

Answer 2

DATE_FORMAT()