TalkPHP - View Single Post

allworknoplay · 04-02-2009, 10:04 PM

Ok, is there any way to make this query better? It seems like I should be able to somehow use less "AND"...

Code:

SELECT * FROM users WHERE user_id != '5' AND user_id != '6' AND user_id != '9' AND user_id != '3';

04-02-2009, 10:04 PM	#1 (permalink)
allworknoplay The Gregarious Join Date: Feb 2009 Location: New York Posts: 645 Thanks: 64	SQL code...if NOT.... Ok, is there any way to make this query better? It seems like I should be able to somehow use less "AND"... Code: SELECT * FROM users WHERE user_id != '5' AND user_id != '6' AND user_id != '9' AND user_id != '3';