Javatpoint Logo
Javatpoint Logo

MySQL SUBSTRING() Function

The substring() 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:


MySQL String SUBSTRING() Function

Example 2

Output:


MySQL String SUBSTRING() Function

Example 3

Output:


MySQL String SUBSTRING() Function

Example 4

Output:


MySQL String SUBSTRING() Function
Next TopicMySQL String




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA