select if(SUBSTR('06622200556',1,2)='06',0,1) from t_member_product_adb limit 2 输出结果为:0,0 转载于:https://www.cnblogs.com/JAYIT/p/9037518.html