How to Avoid Leading Wildcards That Kill Indexes

LIKE '%text' forces a full table scan.

#mysql #like #index #performance #howto #search

https://www.youtube.com/watch?v=HYdQSccv-AI