Examveda
Examveda

Which operator performs pattern matching?

A. BETWEEN operator

B. LIKE operator

C. EXISTS operator

D. None of these

Answer: Option B

Solution(By Examveda Team)

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.

Join The Discussion

Related Questions on Sql Miscellaneous

Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

A. SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');

B. SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');

C. SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');

D. SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');