select from column where value in a list or no such column

Question

Ok here's my task

I have a list of lenders like this

lender  name
1       lender 1
2       some other lender

and I have a list of states like this

lender  state
1       AK
1       WY
1       NY
2       AZ
2       FL

so i have an area, for example FL, i need to select all lenders where state = "FL" OR where state is not defined at all (this would mean ANY state)

I can't figure out how to do the second part (where state is not defined). Any help to figure out?

Thanks

OR state is NULL ? or do you want to http://stackoverflow.com/questions/915643/select-where-not-exists — Rufinus, May 28 '11 at 16:37

score 1 · Accepted Answer · answered May 28 '11 at 16:38

1

select * from lenders where state='FL' or state is null

answered May 28 '11 at 16:38

UltraInstinct

score 0 · Answer 2 · answered May 28 '11 at 16:37

0

Assuming the "undefined" fields are NULL, you could simply add OR state IS NULL to your query.

answered May 28 '11 at 16:37

dee-see

2 Answers2