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%’;
[UPDATE] – added (yet another) explanation on for comprehensions The * method: This returns the default projection – which is how you describe: ‘all the columns (or computed values) I am usually interested’ in. Your table could have several fields; you only need a subset for your default projection. The default projection must match the … Read more