Slick compare table column with null

Question

Can someone please tell me how do we compare a table column against NULL using slick's lifted embedding. What i want to achieve in mysql: ``` select * from Users where email = '<some_email_addr>' and ( removed = NULL OR removed <= 1 ) ``` It gives me an errors at x.removed === null when i try: ``` val q = for { x <- Users if x.email === email && ( x.removed === null || x.removed <= 1 ) } yield x.removed ``` Thanks

Accepted Answer

Try:

```
x.removed.isNull
```

I think that is what you are looking for

Slick compare table column with null

Solution

Problem