最爱大裤衩
$res['data'] = ShowRecord::find()->where("locate($keyword,'name')>0")->all();
报错,
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't' in 'where clause' The SQL being executed was: SELECT * FROM `record` WHERE locate(t,'name')>0 Error Info: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 't' in 'where clause' )
- 最爱大裤衩 发表了说说where()中怎么使用locate来进行模糊查询
- 最爱大裤衩 2018-04-11 已签到连续签到7天,获得了20个金钱
- 最爱大裤衩 2018-04-10 已签到连续签到6天,获得了20个金钱
- 最爱大裤衩 2018-04-09 已签到连续签到5天,获得了20个金钱