Convert SQL query to Query builder Laravel

Question

I want to convert this SQL query to Query builder Laravel

SELECT * FROM articles ORDER BY (titre LIKE '%book%') DESC

Muminur Rahman · Accepted Answer · 2018-08-14 10:46:19Z

1

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();

edited Aug 14, 2018 at 10:46

answered Aug 14, 2018 at 10:31

Muminur Rahman

6341 gold badge10 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

visulo Over a year ago

great, with variable : orderBy(DB::raw("title LIKE '%$value%'"),'desc') thanks

Muminur Rahman Over a year ago

Thanks. If it works, please accept it as correct answer.

visulo Over a year ago

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 Over a year ago

You may use multiple orderBy functions as below: DB::table('articles')->orderByRaw("(title LIKE '%book%') DESC, (description LIKE '%book%') DESC")->get();

visulo Over a year ago

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

|

Collectives™ on Stack Overflow

Convert SQL query to Query builder Laravel

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related