先上sql
模糊查询spu里面的商品名或者品牌名含有‘肉’字样的商品
// An highlighted block
SELECT * FROM tb_spu WHERE brand_name LIKE '%肉%' or name like '%肉%' AND is_delete='0' AND is_marketable ='1'
这样查询出来的数据and后面的两个条件是失效的,相当于没写
=============================================================
正确操作如下(把like语句加上括号)
// An highlighted block
SELECT * FROM tb_spu WHERE (brand_name LIKE '%肉%' or name like '%肉%') AND is_delete='0' AND is_marketable ='1'
查出来的数据就正常了。。。。