tp5.1连接sqlserver数据库,如何like查询

浏览:432 发布日期:2021/10/29 分类:求助交流 关键字: sqlserver tp5
我用常规的where['name'] = ['like','%张三%'];这样写会有问题,sql语句打印出来是这样的SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT [CARD_MONEY],[Integral],[SHORT_CARDID],[CARDID] FROM [BASIC_MAMBER] WHERE [name] IN ('name','like','%张三%')) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1),为什么变成了where in啊
最佳答案
评论( 相关
后面还有条评论,点击查看>>