How to compare dates correctly?

Question

MySQL

Why is this request

SELECT * FROM matches WHERE CURDATE() > '2018-02-15'

compares dates incorrectly?
The table has such fields, with such dates (field type string)
And you need to make two queries, such as if the current date is > (greater than) the given date in the data_event field .... and the second query if the current date is < (less than) than the date in the data_event field.

Answer 1

In my opinion, because in this form, mysql casts types to a string and compares them as strings.
Those. need something like this:CURDATE() > DATE('2018-02-14')