Discussion :: SQL Basics
- Which operator performs pattern matching?
- 1=% (percent sign) represents zero, one, or more characters.
- 2=_ (underscore) represents exactly one character.
Whatsapp
Facebook
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:
Be The First To Comment