[shrdlu2]

Yeah, I would think functional/function-based indexes should be mentioned. Add an index or add a redundant column? Almost all of time I would prefer the index.

Of course if your database can't be changed then maybe you can use this trick if there is already a suitable indexed column.

[aarondf]

Yeah I could definitely add some links to or descriptions of functional indexes.

If you're curious, here's a video I did on it: https://planetscale.com/courses/mysql-for-developers/indexes...