Search code examples
scalascalaqueryslick

How to use SQL "LIKE" operator in SLICK

Maybe a silly question. But I have not found an answer so far. So how do you represent the SQL's "LIKE" operator in SLICK?

Solution

  • Exactly as you normally would!

    val query = for {
  coffee <- Coffees if coffee.name like "%expresso%"
} yield (coffee.name, coffee.price)

    Will generate SQL like

    SELECT name, price FROM coffees WHERE NAME like '%expresso%';