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.
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();