案例在教义查询构建器where子句中不起作用 [英] Case not work in doctrine query builder where clause
本文介绍了案例在教义查询构建器where子句中不起作用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在原则的where子句中遇到mysql CASE问题,
I am facing issue with mysql CASE in where clause of doctrine,
$rides_q1 = $em->getRepository('IRRideBundle:Ride');
$query = $rides_q1->createQueryBuilder('a')
->where('(CASE WHEN a.ephemeral = 1 THEN a.date_beginning < NOW() AND a.date_ending > NOW()ELSE a.ephemeral = 0 END) AND a.active = 1 AND a.status = 5')
->getQuery();
$ridesQuery = $query->execute();
**[Syntax Error] line 0, col 93: Error: Expected Doctrine\ORM\Query\Lexer::T_ELSE, got '<'**
[2/2] QueryException: [Syntax Error] line 0, col 93: Error: Expected Doctrine\ORM\Query\Lexer::T_ELSE, got '<' +
[1/2] QueryException: SELECT a FROM IR\RideBundle\Entity\Ride a WHERE (CASE WHEN ephemeral = 1 THEN date_beginning < NOW() AND date_ending > NOW()ELSE ephemeral = 0 END)
我想准备这个sql查询,它可以与phpmyadmin一起正常工作
I want to prepare this sql query, its working fine with phpmyadmin
SELECT * FROM ride WHERE (CASE WHEN ephemeral = 1 THEN date_beginning < NOW() AND date_ending > NOW()ELSE ephemeral = 0 END) AND active = 1 AND `status_id` = 5 ORDER BY `date_ending` DESC
推荐答案
您在 WHERE
中的 CASE
表达式是错误的。您可以将其转换为正常的复合条件,例如
Your CASE
expression in WHERE
is wrong. You could convert it to normal compound condition like
(CASE WHEN a.ephemeral = 1 THEN a.date_beginning < NOW() AND a.date_ending > NOW()ELSE a.ephemeral = 0 END)
To
SELECT * FROM ride
WHERE ((a.ephemeral = 1
and a.date_beginning < NOW()
AND a.date_ending > NOW())
OR a.ephemeral = 0)
AND a.active = 1
AND a.status = 5
ORDER BY `date_ending` DESC
这篇关于案例在教义查询构建器where子句中不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文