How to create a filter that does the SQL equivalent of WHERE ... IN for SQLite.Swift

Question

I would like to filter results for the same column with multiple values

example in sql:

SELECT * FROM myTable WHERE status = 1 AND current_condition = ("New", "Working")

this will return all rows from myTable where the status is 1 and the current_condition is "New" OR "Working"

how do I do this in SQLite.swift?

score 0 · Accepted Answer · answered Mar 21 '16 at 15:56

0

You can use raw SQL in Swift. So you can use the string you posted.

I use Filters, gives me more insight.

answered Mar 21 '16 at 15:56

SamuelD

2

To clarify, you can use `["New", "Working"].contains(current_condition)`. – stephencelis Mar 21 '16 at 16:21

1 Answers1