Question

Which string function returns the index of the first occurrence of substring?

(a) INSERT()

(b) INSTR()

(c) INSTRING()

(d) INFSTR()

This question was addressed to me by my school principal while I was bunking the class.

My doubt stems from System Variables in section System, Status and User Variables of MySQL

Answer 1

Right choice is (b) INSTR()

The best I can explain: The string funtion ‘INSTR()’ is used to return the index of the first occurrence of the substring. The function ‘INSERT()’ is used to insert a substring at the specified position up to the specified number of characters.