Like operator with indexes in SQL
Introduction
The SQL LIKE operator is used in a WHERE clause to search for a specified pattern in a cloumn.
The performance and behavior of the LIKE operator in SQL change significantly when used alongside indexes.

