Using CONCAT with Eloquent in Laravel

Question

I want to use concat with eloquent , I have two tables (users) and (cars) From users table I want to use first_name , last_name fields, and from cars table I want to use field called (vin).

$cars   = Car::where(DB::raw('concat(first_name," ",vin," ",make)') , 'LIKE' , '%$search%')->paginate();

first_name field from Users table and the rest from Cars table

please post your code, concat with eloquent you can do it with relation model, you need do some change in your migrations, and insert relation function in yout model User and Car — Diego Cespedes
– Diego Cespedes, Commented Nov 6, 2016 at 10:40
I did relation between Users and Cars , one to many , and it works fine with me with any queries — allaghi
– allaghi, Commented Nov 6, 2016 at 10:51

Amit Gupta · Accepted Answer · 2016-11-06 12:51:39Z

1

You can use join() for this as:

$cars   = Car::join('users', 'cars.user_id', '=', 'users.id')
            ->where(DB::raw('concat(users.first_name," ",cars.vin," ",cars.make)') , 'LIKE' , "%$search%")
            ->select('cars.*')
            ->paginate();

edited Nov 6, 2016 at 12:51

answered Nov 6, 2016 at 12:24

Amit Gupta

17.7k5 gold badges46 silver badges54 bronze badges

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

2 Comments

allaghi Over a year ago

I did some changes with '%$search%' which is '%'.$search.'%'

Amit Gupta Over a year ago

If you use double quotes then you can do that also as: "%$search%"

Collectives™ on Stack Overflow

Using CONCAT with Eloquent in Laravel

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related