title: Using CONCAT with Eloquent in Laravel
body: <p>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). </p>
  
  <pre><code>$cars   = Car::where(DB::raw('concat(first_name," ",vin," ",make)') , 'LIKE' , '%$search%')-&gt;paginate();
  </code></pre>
  
  <p>first_name field from Users table and the rest from Cars table</p>