The LIKE operator is used in SQL to search for a specified pattern in a column. It is commonly used with wildcard characters to enhance search capabilities.