MySQL Query not working as intended

Here is the exact query (copy and pasted)

SELECT *
FROM wp_posts
WHERE post_content LIKE '%Jon 1%'
OR post_content LIKE '%Jonah 1%'
OR post_content LIKE '%Jon. 1%'
OR post_content LIKE '%Jona 1%'
OR post_content LIKE '%Jo 1%'
AND post_status = 'publish'
AND post_type = 'post'

Code (markup):

The problem is that it is still pulling results with a post_status of "inherit" and post_type with 'page'. I want only results with publish as the post_status and "post" as the post_type.

Any idea why it would be doing this? Is it the "OR's"?

 

Whoops! those should have been AND's not OR's... Please remove thread, fixed.

 

replaceing AND for the ORs wont work ether

SELECT *
FROM wp_posts
WHERE (post_content LIKE '%Jon 1%'
OR post_content LIKE '%Jonah 1%'
OR post_content LIKE '%Jon. 1%'
OR post_content LIKE '%Jona 1%'
OR post_content LIKE '%Jo 1%')
AND post_status = 'publish'
AND post_type = 'post'

Code (markup):

add brackets to make the like statement one statment - if you replace with ANDs then the postcomment will have to be like all the terms at once

 

Hi,
It's better using regexp instead of so many like.
Regards,
Nick