Laravel 3 Eloquent How to choose a column as

Question

I am 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'; 

thanks in adv!

Answer 1

Eloquent returns a regular Free request. So you can try something like this (assuming your model name is “User”):

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

Answer 2

This is how I was able to do this in Laravel 5 using select() and pass the col name and alias to this method (here I also use groupby() to limit it to “ DISTINCT ” return values ​​using toarray() to return any array instead of Collection Object :

 $results = asset::select('model_code__c AS option')->whereRAW("model_code__c <> '' AND status = 'A'")->groupby('model_code__c')->get()->toarray();