asked on Could you point how to code an inline if for a select by using Laravel's Eloquent?
Hi Experts
Could you point how to code an inline if for a select by using Laravel's Eloquent?
Accordingly to
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'if(users.aceiteRegulament
Thanks in advance
Could you point how to code an inline if for a select by using Laravel's Eloquent?
Accordingly to
->select('users.id',...',
// This generates an ERROR!
'if(users.aceiteRegulamento ==1, "Sim", "Não") as aceite','users.created_at','users.updated_at')
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'if(users.aceiteRegulament
Thanks in advance
LaravelPHP
Last Comment
RBertora
ASKER
Hi
I'm using Laravel Eloquent and had attempt to use it, also:
But it doesn't run inside the query.
I'm using Laravel Eloquent and had attempt to use it, also:
'(CASE WHEN users.aceiteRegulamento = "0" THEN "Não" WHEN users.aceiteRegulamento = "1" THEN "Sim" ELSE "Não" END) AS aceiteRegulamento'
But it doesn't run inside the query.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Rbertora
Perfectly!!!
Thank you for the help!
Perfectly!!!
Thank you for the help!
Hey Eduardo, thank you very much, muchas gracias / Muito obrigado for the positive review!
From https://stackoverflow.com/questions/6608102/sql-server-inline-if-else
select
case MyFlag
when 1 then 'YES'
when 0 then 'NO'
else 'OOPS'
end
from MyTable
where it's used just like a switch in C-like languages and the other is:
select
case
when MyFlag = 1 then 'YES'
when MyFlag = 0 then 'NO'
-- when some unrelated condition...
else 'OOPS'
end
from MyTable