Like operator with indexes in SQL
· 2 min read
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.