How to speed up MySql Like query ?

For string columns, MySQL indexes the left side of a string. That means an index can speed a like query that has a wildcard on the right side:

SELECT * FROM users WHERE email LIKE "@gmail.com%"

This will be faster with an index column