which operator performs pattern matching in sql

which operator performs pattern matching in sql

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