Use MySQL's substring_index function to solve the problem of coding non-repetition in the project!

Introduction to a Substring_index function

role: intercept strings by keyword
Substring_index (Str,delim,count)
Description: Substring_index (the number of occurrences of the intercepted field, keywords, keywords)
Example: Select Substring_index ("she said, I am a good man, what to do", ",", 2);
Country:

Is intercepted from the second occurrence of the keyword.

However, if the number of times is negative, it will be intercepted from the back, such as

From the back to the second occurrence of the location of the interception, so that the encoding method provides a very good implementation of technical support!

Two coding ideas

Use MySQL's substring_index function to solve the problem of coding non-repetition in the project!