Home / CSE / SQL Basics :: Discussion

Discussion :: SQL Basics

  1. Which operator performs pattern matching?

  2. A.

     BETWEEN operator

    B.

     LIKE operator

    C.

     EXISTS operator

    D.

     None of these

    View Answer

    Workspace

    Answer : Option B

    Explanation :

    LIKE is a keyword that is used in the WHERE clause. Basically, LIKE allows us to do a search based operation on a pattern rather than specifying exactly what is desired (as in IN) or spell out a range (as in BETWEEN).

    The syntax is as follows:
    SELECT "column_name"
    FROM "table_name"
    WHERE "column_name" LIKE {PATTERN}

    {PATTERN} often consists of wildcards. In SQL, there are two wildcards:

    • 1=% (percent sign) represents zero, one, or more characters.
    • 2=_ (underscore) represents exactly one character.


Be The First To Comment