Laravel query builder multiple column in where comparison

Question

I'm using query builder with laravel and i'm trying to get the equivalent of

SELECT name
     , firstname 
FROM emp
WHERE name+' '+firstname LIKE '%test%'

in query builder? How could I have the same result?

What have you tried? Have you even looked at the docs? laravel.com/docs/5.5/queries — Don't Panic
– Don't Panic, Commented Sep 26, 2017 at 9:30

Mr. Pyramid · Accepted Answer · 2017-10-02 00:56:27Z

1

you can do that in whereRaw() like this

DB::table('emp')->whereRaw("name+' '+firstname LIKE '%test%'")->select('name', 'firstname')->get();

hope it's work for you!

Mr. Pyramid

3,9355 gold badges35 silver badges57 bronze badges

answered Sep 26, 2017 at 8:28

Gaurav Gupta

1,7332 gold badges16 silver badges22 bronze badges

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

1 Comment

Thank you very much ! This is what i'm looking for

Siva Ganesh · Accepted Answer · 2017-09-26 08:39:47Z

1

 $result = DB::table('emp')->select('name', 'firstname')->where(DB::raw("CONCAT('name', ' ', 'firstname')"), 'LIKE', '%'. 'test' .'%')->get();

answered Sep 26, 2017 at 8:39

Siva Ganesh

1,4532 gold badges18 silver badges28 bronze badges

Meera Tank · Accepted Answer · 2017-09-26 08:35:45Z

0

Try using CONCAT for multiple column

DB::table('emp')->Where(DB::raw("CONCAT(`name`, ' ', `firstname`)"), 'LIKE', "%test%")->select('name', 'firstname')->get();

hope this will help.

answered Sep 26, 2017 at 8:35

Meera Tank

7196 silver badges13 bronze badges