数据源
SELECT em.country_code FROM edu_major em WHERE em.id='307'
截取下划线右边的数据
SELECT substring_index(em.country_code,'_',-1) FROM edu_major em WHERE em.id='307'
数据源
SELECT em.country_code FROM edu_major em WHERE em.id='307'
截取下划线右边的数据
SELECT substring_index(em.country_code,'_',-1) FROM edu_major em WHERE em.id='307'