Substring_index of "MySQL" string interception

Substring_index (Str,delim,count)

STR: The string to be processed

Delim: Delimiter

Count: Count

Example: str=www.baidu.com

Substring_index (str, '. ', 1)

The result is: www

Substring_index (str, '. ', 2)

The result is: Www.baidu

That is, if Count is a positive number, then it is the left-to-right, and the left of the nth delimiter.

Conversely, if it is a negative number, it is all the content from the right to the right of the nth delimiter, such as:

Substring_index (str, '. ',-2)

The result is: baidu.com

Someone will for, if I ah in the middle of Baidu how to do?

Very simple, two directions:

From the right of the second delimiter to the right of all, and then from the left of the first delimiter:

Substring_index (Substring_index (str, '. ',-2), '. ', 1);

Substring_index of "MySQL" string interception