Subquery with update Laravel eloquent

Question

I write simple query in Postgres

update target_table t
set sort_no = sort_dtl.new_sort_no
from (select sort_no,row_number() over(order by new_sort_key) as new_sort_no
      from target_table
      where t_no = 123
) as sort_dtl
where t.t_no = 123
and t.sort_no = sort_dtl.sort_no

I want to implement the same thing using Laravel eloquent. How can I do that?

Aryan Hasanzadeh · Answer

Hey you can use laravel eloquent for create query and for qreate you can use DB Helper You can see full eloquent documentation here

Subquery with update Laravel eloquent

1 Answers