Which operator performs pattern matching

Which operator performs pattern matching ?

A) LIKE operator B) EXISTS operator
C) BETWEEN operator D) None of these


Which operator performs pattern matching

Answer: A) LIKE operator


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:

% (percent sign) represents zero, one, or more characters.

_ (underscore) represents exactly one character.


More :: Certification Questions on SQL

Subject: SQL – Technology
Job Role: Software Architect , IT Trainer , Database Administration , Analyst

Megha Chandrashekar is a former Special Education Assistant who now spends her days running after her toddlers, all the while pursuing a freelance writing career
Leave a comment