CODEWITHSUNDEEP
androidsqliteboolean-logic
Achilles
Achilles

Reputation: 741

creating SQLITE query using boolean logic (AND, OR, NOT)

I'm using sqlite version 3.7 for my android application, I'm just not sure despite looking on the internet as well as this form, if it supports or if there is an alternative way to use boolean expressions in a query. I know we have to use 1/0 integers if we want to store boolean values into the database. but

for example: WHERE (a=1 || b=1) && c=1

Upvotes: 1

Views: 780

Answers (2)

Aswin Kumar
Aswin Kumar

Reputation: 5278

Use AND, OR, etc. Find more at sqlite docs

Upvotes: 1

chrisendymion
chrisendymion

Reputation: 175

I don't understand.. Why not using classical SQL ? WHERE (a = 1 OR b = 1) AND c = 1

Upvotes: 2

Related Questions