How to display all records that are older than 6 months mysql?

Question

MySQL

Hello!
Is it possible to do this at all?
It works somehow strange, in the month field I have an enum there and all records have 6.
For some reason, it takes not 6 months, but 3, how is this possible?
I put the number 6 instead of the field and it works fine.
mysql 8

`unixtime` < NOW() - INTERVAL `month` MONTH

Answer 1

If you have ENUM there, then the value of the field is not what you see on the screen, but the ordinal number of this option in ENUM.
That is, for ENUM('1', '3', '6') one will give a numerical value of 1, three - 2, six - 3.