select reverse(substring(reverse(number),1,locate('-',reverse(number)) - 1)) from focus_question_tbl
where unit_id='263'
reverse 是反转 instr 是在该字符串反转后,查找'-'字符串,返回位置
where unit_id='263'
select distinct reverse(substring(REVERSE(number),INSTR(REVERSE(number),'-')+1))from focus_question_tbl
where unit_id='263'
where unit_id='263'