How to get sub string in mysql?

In mysql, to get sub string of the string we use SUBSTRING function. This substring function syntax below:

SUBSTRING(string,start_position,length)

Example:

SUBSTRING("nosomovo",3,4)

The result of this statement is “somo”.

nosomovo