mysql匹配查询 桃扇骨 2021-12-11 14:21 162阅读 0赞 1.使用like,但是like在前面加%会让索引失效 SELECT count(1) FROM t\_project WHERE project\_address LIKE('%烟台市%'); 2.使用LOCATE(substr,str)函数/LOCATE(substr,str,pos) SELECT count(1) FROM t\_project WHERE LOCATE('烟台市',project\_address);
还没有评论,来说两句吧...