select caller,SUBSTRING_INDEX(caller, "678",1) from phone 找到678 之前的sql 1234678 2345678 查询出结果 1234 2345