How to speed up MySql Like query ?

Created at: 2019-08-12 16:36:45 Updated at: 2019-08-12 16:37:06

in Database, MySql

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