Laravel Query Builder Multiple Select And Named Columns

Question

I'm new at using Query Builder, today I stuck on Query Builder.I'm trying to do name column also multiple select. Here is what I'm trying to convert query builder :

SELECT 
users.name,
users.surname,
users.avatar_path,
users.city_id,
users.district_id,
users.neighboor_id,
cities.name as city_name
FROM users,cities
WHERE users.city_id = cities.id
AND users.name LIKE 'bar%'

is there any way without using DB::raw() ?

Thank you.

Jignesh Joisar · Accepted Answer · 2019-02-01 11:54:22Z

1

use join query here

DB::table('users')
     ->select('users.name','users.surname','users.avatar_path','users.city_id','users.district_id','users.neighboor_id','cities.name as city_name')
     ->join('users','users.city_id','=','cities.id')
     ->where('users.name','LIKE',$searchText.'%')   //add here your variable
     ->get();

answered Feb 1, 2019 at 11:54

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

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

1 Comment

Baran KARABOGA Over a year ago

Thank you so much it worked :) I understood how it work

Collectives™ on Stack Overflow

Laravel Query Builder Multiple Select And Named Columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related