How to make SQL "NOT LIKE" in Slick

Question

I am new to both Scala and Slick. The query "LIKE" was easy to do.

query.filter(_.name like "%kjelle%") 

but I don’t have time to make the request "DOES NOT LIKE". I couldn’t find an operator that wasn’t like, so my first thought was to try

 query.filter(_.name !like "%kjelle%") 

or

 query.filter(!(_.name like "%kjelle%")) 

but without success.

How can I do this in Slick?

Answer 1

You can try using filterNot :

 query.filterNot(_.name like "%kjelle%")