php/mysql - want to select all NOT NULL, not work right..

[camarosource]

Trying to do the following:

Select fields "user_from, username, user_email FROM database phpusers where user_from does NOT contain "USA" nor are BLANK, and then order by username.

My PHP script is :

$sql = "SELECT user_from, username, user_email FROM phpbb_users WHERE user_from NOT LIKE '%usa%' OR user_from=NULL OR user_from='' ORDER BY username";

//Execute SQL query
$sql_result = mysql_query($sql,$conn) or die(mysql_error());

It seems to be selecting all those without "USA" which is what I want, however seems to be ignoring the part about NOT wanting to select those that are BLANK (NULL).

Help. Thanks

[Roger_Ramjet]

cos you've told it specifically to select those where it is = null

try writing it correctly

OR user_from IS NOT NULL OR user_from != ''