MySQL has supported index expressions for nearly four years, since MySQL 8.0.13. Prior to that, you could accomplish the same thing indirectly by creating a vi

MySQL has supported index expressions for nearly four years, since MySQL 8.0.13. Prior to that, you could accomplish the same thing indirectly by creating a virtual column with the desired expression, and then creating an index over that virtual column. This has been supported for six years, since MySQL 5.7. So at this point all non-EOL versions of MySQL support this.