Which operator is used in the query for pattern matching

Question

Hi!!

Can someone tell me which operator is used in the query for pattern matching?

Answer 1

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

1. % – It matches zero or more characters.

For example- select * from students where studentname like ‘a%’

_ (Underscore) – it matches exactly one character.
For example- select * from student where studentname like ‘abc_’