What is the output of the following MySQL command?
SELECT INSTR('MISSISSIPPI', 'S');

Question

What is the output of the following MySQL command? SELECT INSTR('MISSISSIPPI', 'S');

Accepted Answer

Correct answer: C — In MySQL, the function INSTR(string, substring) returns the position of the first occurrence of the substring in the string (starting index = 1). For 'MISSISSIPPI': M = 1 I = 2 S = 3 (first occurrence)So, INSTR('MISSISSIPPI', 'S') = 3.

Answer

A. 1

Answer

B. 2

Answer

C. 3

Answer

D. 4

What is the output of the following MySQL command? SELECT INSTR('MISSISSIPPI',…