A

Admin • 833K Points
Coach

Q. The string function that returns the index of the first occurrence of substring is . . . . . . . .

  • (A) INSERT()
  • (B) INSTR()
  • (C) INSTRING()
  • (D) INFSTR()
  • Correct Answer - Option(B)
  • Views: 43
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

INSTR(): The INSTR() function in MySQL is used to find the position of the first occurrence of a substring within a string. It returns the index (position) of the first character of the substring within the string. If the substring is not found, it returns 0. The syntax for the INSTR() function is INSTR(string, substring).

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.