SQL substring和substring_index
substring1.substring(‘123456789’,5) ------------------567892.substring(‘123456789’,5,2)----------------563.substring(‘123456789’ from 5)-----------567894.substring(‘123456789’ from 5 for 2) —56substring_index(str,‘x’,‘index’)----------------------x:通
复制链接