张 三(0123456780)
张三三(zhang012)
王六六(025135487)
这种用split怎么截取
SELECT name，name2 FROM `fine_user`
select substr("abc(1234)",1,instr("abc(1234)",'(')-1) as name, substr("abc(1234)",instr("abc(1234)",'(')+1,instr("abc(1234)",')')-(instr("abc(1234)",'(')+1)) as name2
1min目标场景问卷
立即参与
