The SQL keyword __________ is used with wildcards.
2025
The SQL keyword __________ is used with wildcards.
- A.
LIKE
- B.
IN
- C.
NOT IN
- D.
DISTINCT
Attempted by 1730 students.
Show answer & explanation
Correct answer: A
The SQL keyword LIKE is used to search for patterns in strings using wildcards. It supports two main wildcards: % (matches zero or more characters) and _ (matches exactly one character). For example, 'A%' matches any string starting with 'A', and 'A__' matches any three-character string starting with 'A'. The IN keyword checks if a value matches any value in a list, but it does not support pattern matching. NOT IN excludes values in a list, but also does not support wildcards. DISTINCT returns unique values from a column, and it is not used for pattern matching. Therefore, LIKE is the correct keyword for using wildcards in SQL.