Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 29 of 81

MySQL Functions — Question 11

Back to all questions
11
Question

Question 11

What will be returned by the given query ?

SELECT INSTR("INDIA", "DI");
  1. 2
  2. 3
  3. -2
  4. -3
Answer

3

Reason — The INSTR() function in MySQL returns the position of the first occurrence of a substring within a string. The position of "DI" within "INDIA" is at the third position in the string "INDIA". Therefore, the INSTR() function will return 3.