SQL - LIKE Keyword

This condition is used to check a particular pattern of string in the where clause conditions.

% is used to check more than one character _ is used to check only one character.

Select column name from table name where column name like ‘%en%’

Select column name from table name where column name like ‘_eseph’