MySQL intercept string substring_index (Str,oat,index)

Category_search_name similar to the following
0-123: Clothing Shoes and hats 0-123-137-202: Clothing shoes and hats-0-speed food-0 instant noodlesfirst-with the second-(the number between the:) is the first-level category ID (123)Substring_index (Substring_index (Substring_index (Category_search_name, '-', 2), '-',-1), ': ', 1)Substring_index (Category_search_name, '-', 2) means interceptthe second of the Category_search_name string-thebeforeall the fieldssubstring_index (str, '-',-1)represents all fields after the first-after intercepting the STR stringsubstring_index (str, ': ', 1) indicates the first intercept of the STR string:beforeall the fieldsif no symbol is found, the original string is returned

MySQL intercept string substring_index (Str,oat,index)