Laravel 3 Eloquent How to select column as

select laravel alias eloquent laravel-3
darksoulsong picture darksoulsong · Sep 4, 2013 · Viewed 16.3k times · Source

I'm trying to figure out how to give a column an alias using Eloquent.

So, in other words, how do I execute the following mysql query using Eloquent?

SELECT occupation AS test FROM users WHERE occupation = 'PIMP';

Thx in adv!

Answer

amosmos picture amosmos · Oct 28, 2013

Eloquent returns a regular Fluent query. So you can try something like this (assuming your model name is 'User'):

$user = User::where_occupation('pimp')->get(array('occupation as test'));

Related questions

Laravel Eloquent Select CASE?

Is there anyone with experience in PHP & Laravel Eloquent who can help me resolve this statement? I'm trying to inject a CASE... WHEN.. END... inside a raw() method. It seemed like it was completely ignored. The existing documentation hasn't …

Read More
How to show selected value from database in dropdown using Laravel?

I want to show selected value from database into dropdown list on page load. My controller index function is : public function index() { $country_data =DB::table('country')->select('country_id','country_name')->get(); $profile_data= DB::…

Read More
Laravel Fluent add select()s in separate places?

//Earlier in the code, in each Model: query = ModelName::select('table_name.*') //Later in the code in a function in a Trait class that is always called if ($column == 'group_by') { $thing_query->groupBy($value); $thing_query->…

Read More