CODEWITHSUNDEEP
phpmysqllaravel-4query-builder
SNT93
SNT93

Reputation: 476

Custom Column Names having spaces Laravel 4

I want to use a custom column name that has spaces.How can I write the query for this using Laravel 4. I tried

$org = Org::select('name as Organization Name')->where('id',$user->orgId);
$org = Org::select('name as "Organization Name"')->where('id',$user->orgId);
$org = Org::select('name as `Organization Name`')->where('id',$user->orgId);
$org = Org::select('name as (Organization Name)')->where('id',$user->orgId);
$org = Org::select('name as {Organization Name}')->where('id',$user->orgId);

Nothing gave me the solution..

Upvotes: 2

Views: 965

Answers (1)

mirza
mirza

Reputation: 5793

Did you tried using raw ?

Org::select(DB::raw('name as `Organization Name`, status'))->where('id',$user->orgId);

Upvotes: 3

Related Questions