DELETE
FROM   mytable
WHERE  date_col < STR_TO_DATE('2019-05-01', '%Y-%m-%d');