CREATE TABLE my_table (
id INT AUTO_INCREMENT PRIMARY KEY,
date VARCHAR(10)
);
INSERT INTO my_table (date) VALUES
('01/01/2025'),
('12/31/2024'),
('07/04/2025'),
('02/28/2023'),
('06/15/2024');
SELECT date
FROM my_table
WHERE STR_TO_DATE(date) > '2024-02-03'