Db::name('table')->where('id', 1)->field("*, if(substr(sn,1,2)='SY',1,0) as type")->select();tp翻译出来的查询语句是这样的SELECT *, if(substr(sn,`1`,2)='SY',0) as type FROM `table` where id =
1其中1 被识别成了字段`1` 而且if语句也错了。已解决：
$field = ["*", "if(substr(sn,1,2)='SY',1,0) as type"]; 最佳答案
