substr(source text, start index, length)

Let us now check substr(string,start,length) with the following query.

Query

default> select substr('tutorialspoint',2,5) as substring; 

Result

The above query will generate the following result.

substring 
------------------------------- 
utori

The output returns the substring of (tutorialspoint,2,5) is utori. Here, 2 is the index position and 5 is the length.

Kickstart Your Career

Get certified by completing the course

Get Started