Which Operator Is Used In Query For Pattern Matching?

1.	Which Operator Is Used In Query For Pattern Matching?
Answer» LIKE OPERATOR is used for pattern MATCHING, and it can be used as -. % – MATCHES zero or more CHARACTERS. _(Underscore) – Matching exactly one CHARACTER. LIKE operator is used for pattern matching, and it can be used as -. % – Matches zero or more characters. _(Underscore) – Matching exactly one character.

Answer»

LIKE OPERATOR is used for pattern MATCHING, and it can be used as -.

% – MATCHES zero or more CHARACTERS.

_(Underscore) – Matching exactly one CHARACTER.

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

% – Matches zero or more characters.

_(Underscore) – Matching exactly one character.

Discussion