原则查询+ LIKE表达式 [英] Doctrine query + LIKE expression

问题描述

QUERY：

$ b $我有问题要用LIKE表达式创建一个原则查询b

  $ dql =SELECT u FROM Users u JOIN u.group g WHERE g.name LIKE lower（'ADMIN'）; 
 $ query = $ em-> createQuery（$ dql）; 
 $ result = $ query-> getResult（）; 
  

错误：

  QueryException：[Syntax Error] line 0，col 147：Error：Expected Doctrine\ORM\Query\Lexer :: T_STRING，got'lower'
  

LOWER只是一个例子，我需要使用LIKE
EXPRESSION中的其他功能，例如不相关的

如何更改Like Expression以支持双方的功能？

示例： LOWER（uncent（u.login））LIKE LOWER（uncent（'ADMIN'））

解决方案

类似的字符串需要有％符号。如果你想要的东西从ADMIN开始，那么你会写ADMIN％如果你想要的东西结束与ADMIN你会写％ADMIN，最后如果你想要它包含ADMIN然后它将是％ADMIN％。

可能要返回一个字符串，您可以使用教条的CONCAT函数，或者您可以通过PHP执行。

I have problems to create a Doctrine Query with LIKE Expression:

QUERY:

$dql    = "SELECT u FROM Users u JOIN u.group g WHERE g.name LIKE lower('ADMIN')";
$query  = $em->createQuery($dql);
$result = $query->getResult();

ERROR:

QueryException: [Syntax Error] line 0, col 147: Error: Expected Doctrine\ORM\Query\Lexer::T_STRING, got 'lower'

LOWER was just an example, I need to use other functions in LIKE EXPRESSION, for example, unnacent...

How can I change Like Expression to support function on both sides?

Example: LOWER(unaccent(u.login)) LIKE LOWER(unaccent('ADMIN'))

解决方案

The like string needs to have % signs. If you want something that starts with ADMIN then you would write ADMIN% if you want something that ends with ADMIN you would write %ADMIN and finally if you want it to contain ADMIN then it would be %ADMIN%.

Maybe to return a string you can use the CONCAT function of doctrine or you can do it via PHP.

这篇关于原则查询+ LIKE表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！