MySQL MID() Function

 The MID() function in MySQL is used to extract a substring from a given string. It allows you to specify the starting position and the length of the substring. The syntax is:

MID(string, start_position, length)

Parameters:

• string: The string from which you want to extract the substring.
• start_position: The position in the string where the extraction should begin. The first character is at position 1.
• length: (Optional) The number of characters to extract. If not specified, the function will return all characters from the starting position to the end of the string.

Example 1:

SELECT MID('Hello, World!', 1, 5);

Output: 'Hello'

In this case, it starts from position 1 and extracts 5 characters.

Example 2:

SELECT MID('Hello, World!', 8);

Output: 'World!'

Here, it starts from position 8 and extracts the rest of the string.

Example 3 (Negative start position):

SELECT MID('Hello, World!', -6, 5);

Output: 'World'

A negative start position counts from the end of the string. This will start extracting from the 6th character from the end.

Key Notes:

• If start_position is less than 1, MySQL will treat it as 1.
• If length is larger than the remaining string length from the start position, MySQL will just return the substring up to the end of the string.