troubleshooting Question

Could you point how to code an inline if for a select by using Laravel's Eloquent?

Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil asked on
PHPLaravel
5 Comments1 Solution20 ViewsLast Modified:
Hi Experts


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.aceiteRegulamento ==1, "Sim", "Não")' in 'field list' (SQL: select `users`.`id`, `users`.`login


Thanks in advance
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros