Drop MySQL rows where date is less than today

Question

I've got a column date, which has a specific format. dd/mm/yyyy (for ex 31/05/2018). How can i drop rows where date is less than today?

I'm using MySQL5 & PHP7.

EDIT I know it's a simple operation, but actually my date format is "weird", i tried doing

DELETE FROM table WHERE date < '26/06/2017', but it's actually deleting columns aged 2018.

Possible duplicate of [Deleting records before a certain date](https://stackoverflow.com/questions/8359457/deleting-records-before-a-certain-date) — Ben Mohorc, Apr 24 '18 at 23:31
This is a pretty simple, common type of operation. Have you searched for a solution? Have you tried anything? — ChrisGPT was on strike, Apr 24 '18 at 23:32
why have you stored dates other than using a `DATE` type? You're storing it as plain text and this poses issues and you have to CAST that now. — Funk Forty Niner, Apr 24 '18 at 23:33
What you need is `STR_TO_DATE()` https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_str-to-date — Funk Forty Niner, Apr 24 '18 at 23:39
Store dates using the correct data type. Or don't bother with a MySQL database. — Strawberry, Apr 24 '18 at 23:42

score -2 · Answer 1 · answered Apr 24 '18 at 23:32

-2

DELETE FROM table_name WHERE date < NOW()

answered Apr 24 '18 at 23:32

futureweb

are you 100% sure about this? Look at their dating format again. – Funk Forty Niner Apr 24 '18 at 23:34
had they used the proper column type, then your answer would have worked. This wasn't the case, unfortunately. – Funk Forty Niner Apr 24 '18 at 23:36
1

Agreed sorry take a look here - https://stackoverflow.com/questions/1861489/converting-a-date-in-mysql-from-string-field – futureweb Apr 24 '18 at 23:38

1 Answers1