Re: [sqlite] Select * from table where field = "value" does not work when "value" is also a field....

2009/10/13 Hillebrand Snip : > I have a database with the following fields: > 1) Status (it will hold values like "Open", "Closed", "Submitted"... etc...) > 2) Closed (boolean field which contains 1 or 0) > > If i enter a query like:  Select * from Issues where Status !=

[sqlite] Select * from table where field = "value" does not work when "value" is also a field....

I have a database with the following fields: 1) Status (it will hold values like "Open", "Closed", "Submitted"... etc...) 2) Closed (boolean field which contains 1 or 0) If i enter a query like: Select * from Issues where Status != "Closed" i get all records (even the ones with Status=Closed).