Forum Laravel select help?

posted 9 years ago

Database

Last updated 2 years ago.

replied 9 years ago

Or even easier example,

Model::addSelect('COUNT(*) as total')->get();

replied 9 years ago

You should use accessors to create calculated attributes on your model: http://laravel.com/docs/4.2/eloquent#accessors-and-mutators

replied 9 years ago

You need to use the "raw" method on the DB facade.

use DB;

Model::select(DB::raw("IF(premium > 0, 'yes', 'no') as PremiumYesNo"))->get();

Model::addSelect(DB::raw('COUNT(*) as total'))->get();

Those should work for you.

filip01 filip01 Joined 2 Jan 2015

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community