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

MySQL Functions — Question 12

Back to all questions
12
Question

Question 12

If the substring is not present in a string, the INSTR() returns:

  1. -1
  2. 1
  3. NULL
  4. 0
Answer

0

Reason — When the substring is not found within the string, the INSTR() function in MySQL returns 0.