I am indexing email addresses, and I want to be able to search by domain name. I can’t use a regular index for this, I would need to to a query like:
SELECT ... FROM users WHERE email LIKE '%.com'
That query would, of course, not use indexes.
I have heard about MySQL needs its own built-in calculated indexes. The ability to create an index based on some expression.
So how can we solve this problem ?