请教一sql语句。

[米娜Rose]

有没有这种情况：

在title like‘%美女%’or title‘%帅哥%’

并且还要 delete = 'false'

求一sql语句能实现以上功能。

[johndii]

用括号就可以吧

[zcxverygood123456]

title (like‘%美女%’or title‘%帅哥%’) and delete = 'false'

[wuyq11]

select from tb where (title like '%美女%' or title '%帅哥%')
and delete = 'false'

[chen8410]

(title like‘%美女%’or title like‘%帅哥%') and delete=0 --数据库中false用0表示

[米娜Rose]

呵呵，谢谢，我试试哦。

[米娜Rose]

谢谢大家。