Informatics Practices

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

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

SQL Queries

3 Likes

Answer

0

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

Answered By

3 Likes


Related Questions