I want to convert this SQL query to Query builder Laravel
SELECT * FROM articles ORDER BY (titre LIKE '%book%') DESC
Add a comment
|
1 Answer
Updated: Try the following code:
DB::table('articles')->orderBy(DB::raw("title LIKE '%$value%'"),'desc')->get();
I think the following one also solves your problem:
DB::table('articles')->orderByRaw("(title LIKE '%book%') DESC")->get();
6 Comments
visulo
great, with variable : orderBy(DB::raw("title LIKE '%$value%'"),'desc') thanks
Muminur Rahman
Thanks. If it works, please accept it as correct answer.
visulo
pls, how do I do to add a second field 'description' : DB::table('articles')->orderByRaw("(title, description LIKE '%book%') DESC")->get(); not work!
Muminur Rahman
You may use multiple orderBy functions as below: DB::table('articles')->orderByRaw("(title LIKE '%book%') DESC, (description LIKE '%book%') DESC")->get();
visulo
I fixed the problem, it had another table with the description field, so i have to add the name of the table with the description field : articles.description thanks again
|