The SQL keyword __________ is used with wildcards.

2025

The SQL keyword __________ is used with wildcards.

  1. A.

    LIKE

  2. B.

    IN

  3. C.

    NOT IN

  4. 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.

Explore the full course: Bpsc