using casting in where clause laravel

Question

How do I get this to work correctly?

$listings->where('CAST(number_of_floors as DECIMAL(9,2))', '=', 1);

Listings is simply

Listings:where('user_id','=',1)

user_2873052 · Answer

Use DB::raw like this:

$listings->where(DB::raw('CAST(number_of_floors as DECIMAL(9,2))'), '=', 1);

or whereRaw:

$listings->whereRaw('CAST(number_of_floors as DECIMAL(9,2)) = ?', [1]);