Question

Which MySQL string function is used to extract a substring from a given string based on a specified starting position and length? 

Options

• SUBSTRING_INDEX()

• LENGTH()

• MID()

• TRIM()

Answer 1

MID()

Explanation:

The syntax of the MID() function: 

MID(string, start_position, length)