search error

NZ_Kiwis

 
SELECT TOP 100 * FROM [Table1] [dbo].[Table1] WHERE MemberShipStar IS NULL OR MemberShipStar  >= 1 AND EmailAddress = 'email@example.org' order by ID desc

I want this to return results where membership star rating is null or greater than 0 and where an email address is matched.

This is what I have but all results are shown? why?

bradgrafelman

Operator precedence is probably why, although I can't say for sure since I don't know which DBMS you're using.

You have this:

foo IS NULL OR foo >= 1 AND bar = 'foobar'

which is usually the same as saying this:

foo is NULL OR (foo >= 1 AND bar = 'foobar')

except I think you meant to say this:

(foo is NULL or foo >= 1) AND bar = 'foobar'

jeepin81

I believe this is what you're after:

$sql = "SELECT TOP 100 * FROM [Table1] [dbo].[Table1] WHERE (MemberShipStar IS NULL OR MemberShipStar >0) AND (EmailAddress = 'email@example.org') order by ID desc";

HTH

edit...
what brad said.