投放查询构建器laravel [英] Cast in query builder laravel

问题描述

我想在查询生成器laravel中cast排序

I want to cast orderBy in query builder laravel

因为我的price是varchar类型..

because my price is varchar type..

因此，当进行排序时...结果远非我想要的...

so when it's sorting...the result is far from I want...

我的脚本是这样的

DB::table('test')->where(...)->orderBy('price')->get();

我已经尝试过类似的方法

i already try something like this

$query = CAST(price AS DECIMAL(10,2)) DESC;
DB::table('test')->where(...)->orderBy($query)->get();

如何强制转换OrderBy查询生成器，以便对price desc

how can I cast OrderBy query builder so I can sort price desc

推荐答案

尝试使用orderByRaw():

$query = "CAST(price AS DECIMAL(10,2)) DESC";
DB::table('test')->where(...)->orderByRaw($query)->get();

这篇关于投放查询构建器laravel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！