133

MySQL SUBSTR() Function

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

Syntax

Parameter:

Str: Main string

Len: length for substring

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

Example 1

Output:

Example 2

Output:

Example 3

Output:

Example 4

Output: