Laravel if statement in query

Question

I am beginner php developer.

I have this code:

Model::selectRaw('clients.*, if((client_company_infos.name != "" , client_company_infos.type == 1),  client_company_infos.name, concat(client_infos.first_name, " ", client_infos.last_name)) as name')
            ->leftJoin('client_company_infos', 'client_company_infos.client_id', '=', 'clients.id')
            ->leftJoin('client_infos', 'client_infos.client_id', '=', 'clients.id')
            ->get();

I have error:

"message": "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 1), client_company_infos.name, concat(client_infos.first_name, " ", client_i' at line 1 (SQL: select clients.*, if((client_company_infos.name != "" , client_company_infos.type == 1), client_company_infos.name, concat(client_infos.first_name, " ", client_infos.last_name)) as name from clients left join client_company_infos on client_company_infos.client_id = clients.id left join client_infos on client_infos.client_id = clients.id where clients.deleted_at is null)",

When I make:

Model::selectRaw('clients.*, if(client_company_infos.name != "",  client_company_infos.name, concat(client_infos.first_name, " ", client_infos.last_name)) as name')
            ->leftJoin('client_company_infos', 'client_company_infos.client_id', '=', 'clients.id')
            ->leftJoin('client_infos', 'client_infos.client_id', '=', 'clients.id')
            ->get();

It's work fine. Problem. I with second if. How can I. repair it?

Please help me

The equal operator in MySQL is =, not ==.

Jonnix
– Jonnix

2020-10-20 10:24:02 +00:00
Commented Oct 20, 2020 at 10:24 — Jonnix
– Jonnix, Commented Oct 20, 2020 at 10:24

STA · Accepted Answer · 2020-10-20 10:46:06Z

2

There is no operator == in MySql.

You need to replace the condition with the following:

client_company_infos.type = 1

edited Oct 20, 2020 at 10:46

STA

35.3k9 gold badges49 silver badges62 bronze badges

answered Oct 20, 2020 at 10:27

Nick

5462 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel if statement in query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related