2 ms·
Better databases will let you creat indexes on whatever functions of a field you want.
by CuriouslyC 5y ago
Better databases will let you creat indexes on whatever functions of a field you want.
- evanelias 5y agoMySQL 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.