Pull back data from MySQL but exclude specific records?

[galvin]

I want to write a mysql statement to pull user info from a table, but I want to exclude specific users.    Below is the query with the part i need help with in plain english (starting with "WHERE...").  Can someone tell me how I can write that so that MySQL understands it ...

 

$user_set = mysql_query("SELECT * FROM users
WHERE userid IS NOT EQUAL TO 18 or 33 or 26 or 27 or 47 or 21 or 44 or 45");

 

I tried this but it's clearly wrong  :-\ ....

 

WHERE userid != 18 || 33 || 26 ||27 || 47 || 21 || 44 || 45 || 22 || 46

 

 

[Pikachu2000]

You can either store the values in an array and implode() them in the query string, or just list them within the parentheses separated by commas. As long as they're numeric, there's no need to have each value in quotes.

$not = array(18, 33, 26, 27, 47, 21, 44, 45, 22, 46);
$query = "SELECT * FROM users WHERE userid NOT IN( " . implode ', ', $not) . ")";
$user_set = mysql_query( $query );

[galvin]

perfect, thanks!!!!