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:

World telecommunication day ?
PARAM series of supercomputer developed by
Founder of WikiLeaks is
Which of the following does not comes under the category of Digital computers
A computer is a/ an _____________ device