If there is only one field in the table:
ID？
123abc
456 HD
890ghi
Now, the first three digits will be a field named id 1, and the last three digits will be another field named id2. You can use the following statement:
Choice? substring(id， 1，3)？ id 1，substring(id，4，3)？ id2？ From where? Table name results are as follows:
id 1？ id2
123 ? all but dissertation (ABD)
456 ? Excellent
890 ? butter
Substring function shows that a * * * needs three parameters, the first parameter is the string to be intercepted, the second parameter is the starting position of interception, and the third parameter is the length of interception.