alter PHP sql query and syntax help with MySQL

I have the follow snippet of code that I need to update.  I need to exclude blog_id 3,4,5,7 and I thought I could just append multiple OR statements to the end and reference the != but that is not working...can someone show me a sample of how to edit this query to exclude multiple blog_id?

$query = "SELECT * FROM " . $wpdb->base_prefix . "blogs WHERE spam != 1 AND deleted != 1 AND blog_id != 1";

Open in new window

pda4meAsked:
Who is Participating?
 
k_romychCommented:
try it like this
$query = "SELECT * FROM " . $wpdb->base_prefix . "blogs WHERE spam != 1 AND deleted != 1 AND blog_id NOT IN (1,3,4,5,7) " 

Open in new window

0
 
Lukasz ChmielewskiCommented:
0
 
pda4meAuthor Commented:
Perrrfecto!!!  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.