How do you perform the following SQL operation in Slick:
select * from tablename where label in ('A', 'B');
Haven't been able to find in the documentation or elsewhere.
Asked
Active
Viewed 394 times
1 Answers
2
The Slick operator is inSet. (I assume in collided with something.)
For example:
tablename.filter(_.label inSet Set("A", "B")).result
Michael Lorton
- 43,060
- 26
- 103
- 144
-
Thanks! Could you give an example of how to write the query using this operator? – Geekster May 08 '17 at 13:27
-
@Geekster `table.filter(r => r.label.inSet(labels)).result` – nmat May 08 '17 at 13:38
-
`labels` here would be a list like 'A, B'? – Geekster May 08 '17 at 13:47
-
1@Geekster -- any `Traversable` will do, so List, Set, Stream, whatever. And, I don't like nmat's example. I would write `table.filter(_.label inSet labels).result` – Michael Lorton May 08 '17 at 17:35
-
@Malvolio This works well! Thanks. Could you update your answer with this bit. I will accept your answer then. – Geekster May 08 '17 at 22:54