MySQL String SUBSTR() Function

MySQL SUBSTR() Function

The substr() is a String function of MySQL. This function returns the substring from the given string.

  select substr(Str, pos);  Select substr(Str from pos);  Select substr(Str, pos, len);  Select substr(Str from pos for len);  

Str: Main string

Len: length for substring

Pos: position the start the substring from the given string.

Output:

Output:

Output:

Output:

Next TopicMySQL String