Anorm LIKE clause with String Interpolation

5
votes

Is it possible to use LIKE clause with String Interpolation in Anorm?

// e.g. this doesn't work
SQL"SELECT * FROM users WHERE last_name LIKE $lastName%".as(userParser.*)

UPDATED: I need SQL statement that selects all users with a last name starting with given letters e.g. :

SELECT * FROM users WHERE last_name LIKE 'Smi%';
1
scalaanorm

1 Answers

5
votes

If expected WHERE clause is something like WHERE last_name LIKE '%pattern%' you will have to prepare string before passing it as argument.

SQL"""SELECT * FROM users WHERE last_name LIKE ${"%"+lastName+"%"}""".
  as(userParser.*)