Search code examples
mysqlsqldelete-row

auto delete rows according to a date field using mysql

I have a table with a field end date. I would like that all rows that contain a record in the end date field get deleted when the date is passed.

Once I have the right msyql syntax/command, I can make a cron job from it.

Can anyone help me out? Thanks in advance!

Solution

  • or something like this:

    DELETE FROM db_table WHERE end_date<NOW() AND end_date IS NOT NULL