Tag: mysql substring function

MySQL SUBSTRING Function

Example

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

SELECT SUBSTRING("SQL Tutorial", 1, 3) AS ExtractString;

Definition and Usage

The SUBSTRING() function extracts a substring from a string (starting at any position). Continue reading MySQL SUBSTRING Function

MySQL MID Function

Example

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

SELECT MID("SQL Tutorial", 5, 3) AS ExtractString;

Definition and Usage

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

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

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

Note: The position of the last character in the string is -1.

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

Note: The MID() and SUBSTR() functions equals the SUBSTRING() function. Continue reading MySQL MID Function