I need to create a complex SQLite statement

Question

I need to create a complex SQLite statement.

I need a SQLite statement like this

if ((part ==1 || part == 2) && isFree==YES)

I created statement like this

@"SELECT * FROM book abook WHERE abook.part=0 OR abook.part=1 AND abook.isFree!=0"

Could you check please. Is it a correct statement?

possible duplicate of [SQL Logic Operator Precedence: And and Or](http://stackoverflow.com/questions/1241142/sql-logic-operator-precedence-and-and-or) — kev, Apr 02 '12 at 14:17
Just a question: Have you tried your Statement yourself? Try something like: http://sqlitebrowser.sourceforge.net (googled it, never tried) — Christian Kuetbach, Apr 02 '12 at 14:41
@ckuetbach, I wasn't sure in this statement. I didn't tried. — Voloda2, Apr 02 '12 at 14:49
I think your statement misses the parenthesis, like mentioned beneath. — Christian Kuetbach, Apr 02 '12 at 14:50

score 4 · Answer 1 · answered Apr 02 '12 at 14:15

4

Try this

SELECT * FROM book abook WHERE (abook.part=0 OR abook.part=1) AND abook.isFree!=0

answered Apr 02 '12 at 14:15

rs.

score 2 · Accepted Answer · answered Apr 02 '12 at 14:16

2

You need to use brackets:

SELECT * FROM book abook WHERE (abook.part=0 OR abook.part=1) AND abook.isFree!=0

answered Apr 02 '12 at 14:16

GManz

2 Answers2