Shulou(Shulou.com)06/01 Report--

One field, oldNum, is stored as: "1Magne2, 3pyrr4, 5"; there is also a possibility that "10pd11, 12jpg12, 13, 14", taking only the first few fields.

In a situation like this. Initially consider using:

The LOCATE () function of mysql. But I found that it could not be realized. Because the length before the comma is uncertain.

It's best to decide to use the function substring_index (oldNum,',',3). 3 is the quantity you want to take.

After being separated by a comma, take the data before the number of commas.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.