which operator does pattern matching in sql

which operator does pattern matching in sql

which operator does pattern matching in sql. There are any references about which operator does pattern matching in sql in here. you can look below.