415.

Tuning SQL LIKE using indexes

use-the-index-luke.com/sql/where-clause/searching-for-ranges/like-performance-tuning

Avoid LIKE expressions with leading wildcards (e.g., '%TERM').

sql