Functional indexes store the result of an expression rather than a value from a database column (or columns).
In this video, we discuss an example of where this may be helpful and demonstrate the syntax of creating a functional index in MySQL.
Functional Index Documentation:
https://dev.mysql.com/doc/refman/8.0/...