带有字符串插值的 Anorm LIKE 子句 [英] Anorm LIKE clause with String Interpolation

问题描述

是否可以在 Anorm 中使用带有字符串插值的 LIKE 子句?

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

更新:我需要 SQL 语句来选择姓氏以给定字母开头的所有用户，例如:

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%';

推荐答案

如果预期的 WHERE 子句类似于 WHERE last_name LIKE '%pattern%' 您将必须在将其作为参数传递之前准备字符串.

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

这篇关于带有字符串插值的 Anorm LIKE 子句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！