CODEWITHSUNDEEP
androidsqlite
user1555754
user1555754

Reputation: 339

SQLite query with 2 conditions on 2 columns

Hi is there posibility to construct SQLite query like this SELECT * FROM master WHERE (age=1 OR age=4) AND WHERE city LIKE '%Bo%'

Is a correct version of this query or queries on 2 columns are imposible?

Upvotes: 1

Views: 158

Answers (1)

Sam
Sam

Reputation: 86948

Yes. However you can only use the keyword WHERE once, simply combine you conditions like this:

SELECT * FROM master WHERE (age=1 OR age=4) AND city LIKE '%Bo%'

Upvotes: 3

Related Questions