More than 5 years have passed since last update.

【Laravel 5.2】OrderBy句のキャスト

Posted at 2016-10-21

文字列を数値としてOrderByしたいときー。

例：priceという列がvarchar

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

CAST()で使えるやつ

BINARY[(N)]
CHAR[(N)]
DATE
DATETIME
DECIMAL[(M[,D])]
SIGNED [INTEGER]
TIME
UNSIGNED [INTEGER]