mysql functions in query builder in laravel

Question

I want to use the function in MySQL like convert(name use gbk).

How can I use this with Laravel's query builder with?

I tried ->orderBy(convert(name using gbk)) but it doesnt work.

Answer 1

You need to use the Raw function of eloquent.

DB::raw(your sql)

In your case, the following query should work:

->orderBy(DB::raw('convert(name using gbk)'))

If you want to use raw sql in your where statements, your can use the shortcut function whereRaw() and for a select the selectRaw() function.