mysql if判断

select  if(SUBSTR('06622200556',1,2)='06',0,1) from t_member_product_adb limit 2

  输出结果为:0,0

posted @ 2018-05-14 18:22  Lost blog  阅读(254)  评论(0编辑  收藏  举报