Question

In SQL, which 'LIKE' pattern matches any sequence of zero or more characters?

• A. -
• B. ^
• C. !
• D. %

Answer 1

Answer:

D. %

• SQL pattern matching enables you to use _ to match any single character and % to match an arbitrary number of characters (including zero characters).
• In MySQL, SQL patterns are case-insensitive by default.
• Some examples are shown here. Do not use = or <> when you use SQL patterns.