App Logo

No.1 PSC Learning App

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

A-

B^

C!

D%

Answer:

D. %

Read Explanation:

  • 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.

Related Questions:

Internal storage used in first generation computer is
Primary input device is
Founder of www is
Arrange in ascending order the units of memory TB, KB, GB, MB___________
Father of computer science is