sql语句:SELECT DISTINCT s.`id` ,s.`shopname` FROM shop s LEFT JOIN goods g ON s.id=g.`shopid` WHERE (shopname LIKE'%包子%') OR (`name` LIKE'%包子%')
查询结果:
ajax调用controller层查询的结果:
sql语句:SELECT DISTINCT s.`id` ,s.`shopname` FROM shop s LEFT JOIN goods g ON s.id=g.`shopid` WHERE (shopname LIKE'%包子%') OR (`name` LIKE'%包子%')
查询结果:
ajax调用controller层查询的结果:
连表去重 最好不要用distinct 可以用group by;另外disinct 后面跟*应该不行 要跟具体字段 比如select disinct id from XXX