select mihao,substring(t1.kaohao, -3) from t_zhaosheng_zhiyuan as t1 where substring(t1.kaohao, -3) in (‘030‘,‘106‘) order by field(substring(t1.kaohao, -3) ,‘192‘,‘030‘,‘106‘);
mysql考生号后三位对出密号
原文：https://www.cnblogs.com/littlehb/p/11517380.html
