SQL Date Comparison

To find all rows with dates that match an entered date string, ignoring any time stored...

WHERE DATE_FORMAT(myDate, '%d/%m/%Y')= DATE_FORMAT(STR_TO_DATE('07/12/2022','%d/%m/%Y),'%d%m%Y')

Bibliography