Which operator is used in query for pattern matching?

LIKE operator is used for pattern matching, and it can be used as -.

 

% – Matches zero or more characters.

_(Underscore) – Matching exactly one character.

Example -.

 

Select * from Student where studentname like 'a%'

Select * from Student where studentname like 'ami_'