How to get string position in another string in mysql?

In mysql, to find position of the string in another string we use POSITION function. Here! Position function syntax:

POSITION(substring IN string)

Example:

POSITION("somo" IN "nosomovo")

The result of this statement is 3.

 

Nosomovo