How to create a query like %-_[1-9]-%?

Question

MySQL

There is a database, it is impossible to form a request.
The table has a field with the following content: `10-08-2016`
I would like to make a selection by quarters. In this case, a sample of 9 months.
I use the query:
SELECT * FROM users.data WHERE date_sp LIKE "%-_[1-9]-%"
following the logic, it should display a record with the date `10-08-2016`. But unfortunately it returns an empty result.

Answer 1

SELECT * FROM users.data WHERE STR_TO_DATE(date_sp,' %d-%m-%Y') > DATE_SUB(now(), INTERVAL 9 MONTH)

If the field is varchar

Answer 2

Just in case.
LIKE does not know how to range valid values, but REGEXP can. And although in this case it would be more correct to use STR_TO_DATE, but in some similar cases this is not possible.
A solution to the problem with REGEXP:

SELECT * FROM users.data WHERE date_sp REGEXP "^(\d{2})-0[1-9]-(\d{4})$"