Challenger App

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:

അപ്പർ പ്രൈമറി ക്ലാസുകളിലേക്കുള്ള ഐ.സി.ടി ആക്ടിവിറ്റി പുസ്തകങ്ങൾ അറിയപ്പെടുന്നത് ?
Mainframe computer support ___ users.
Hardware is the____________
Example for non emissive display is
The protocol used to access web based information