Question

____________________________________ is used to search for a specific pattern in a column.

• A. Between operator
• B. In operator
• C. Like operator
• D. Null operator

Hint:

Use LIKE with % and __ wildcards to perform flexible string pattern searches in SQL.

Answer 1

The Correct Option is C

Step 1: Understanding pattern matching.
In SQL, to search for a specific pattern within text data, the LIKE operator is used along with wildcards.
Step 2: Wildcards with LIKE.
- % represents zero, one, or many characters.
- __ represents exactly one character.

Step 3: Example.
\begin{verbatim} SELECT name FROM students WHERE name LIKE 'A%'; \end{verbatim} This will return all names starting with 'A'.
Step 4: Eliminate wrong options.
- Option 1: BETWEEN checks ranges, not patterns.
- Option 2: IN checks specific values, not patterns.
- Option 4: NULL operator checks for NULL values.

Final Answer: \[ \boxed{\text{LIKE operator}} \]