Which operator is used in the 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_’