MySQL不喜欢不工作[关闭]

For example, I use this:

WHERE titel LIKE '%armband%' OR titel LIKE '%armreif%' AND titel NOT LIKE '%herren%'

But still get results which include words like 'Herrenarmband' and so on. Whats wrong here?

try this

WHERE (titel LIKE '%armband%' OR titel LIKE '%armreif%') AND (titel NOT LIKE '%herren%')