Which operator performs pattern matching ?

The operator that performs pattern matching is typically known as the "like" operator in SQL (Structured Query Language). It is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards often used in conjunction with the "like" operator:

• %: The percent sign represents zero, one, or multiple characters
• _: The underscore represents a single character

Here are some examples:

1. WHERE column LIKE 'a%': Finds any values that start with "a"
2. WHERE column LIKE '%a': Finds any values that end with "a"
3. WHERE column LIKE '%or%': Finds any values that have "or" in any position
4. WHERE column LIKE '_r%': Finds any values that have "r" in the second position
5. WHERE column LIKE 'a_%_%': Finds any values that start with "a" and are at least 3 characters in length

Note: SQL is case insensitive.