Question

which clause is used for pattern matching? what are the 2 main characters used for matching the pattern​

Answer 1

Answer:

In SQL, the LIKE keyword is used to search for patterns. Pattern matching employs wildcard characters to match different combinations of characters. The LIKE keyword indicates that the following character string is a matching pattern.

I hope this may help you..

Answer 2

Pattern matching

Explanation:

• SQL pattern matching allows you to look for patterns in data if you do not know the precise word or phrase you're seeking.

• A WHERE clause in SQL define that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria. .

• In brief SQL WHERE clause is employed to extract only those results from a SQL statement, such as: SELECT, INSERT, UPDATE, or DELETE statement.

• Regular expression pattern-matching are often performed with either one character or a pattern of 1 or more characters in parentheses, called a personality pattern.

• Metacharacters have special meanings