Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.0k views
in Technique[技术] by (71.8m points)

scala - Anorm LIKE clause with String Interpolation

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%';
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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.*)

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...