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

  • (A) INSERT()
  • (B) INSTR()
  • (C) INSTRING()
  • (D) INFSTR()
💬 Discuss
✅ Correct Answer: (B) INSTR()
Explanation: 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).

Published by Ritu Nagar ⭐ 4.39K Points at 22-Mar-2025 12:41 pm in MySQL

Explanation by: Ritu Nagar
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).

💬 Discussion

📊 Question Analytics

👁️
116
Total Visits
📽️
2 y ago
Published
🎖️
Ritu Nagar
Publisher
📈
88%
Success Rate