MySQL SUBSTR() Function

Extract a substring from a string (start at position 5, extract 3 characters):

The SUBSTR() function extracts a substring from a string (starting at any position).

The position of the first character in the string is 1.

10 11 12 S Q L T u t o r i a l

-12 -11 -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 S Q L T u t o r i a l

functions equals to the SUBSTRING() function.

string, start, length )

string

start

length )

Required. The string to extract from start Required. The start position. Can be both a positive or negative number. If it is a positive number, this function extracts from the beginning of the string. If it is a negative number, this function extracts from the end of the string. The position of the first character in the string is 1 and the position of the last character in the string is -1 length Optional. The number of characters to extract. If omitted, the whole string will be returned (from the start position)

From MySQL 4.0

Extract a substring from the text in a column (start at position 2, extract 5 characters): SELECT SUBSTR(CustomerName, 2, 5) AS ExtractString

characters):

❮ MySQL Functions