Laravel Eloquent setting up a subquery in the select part of the SQL

Question

SELECT *, (
    SELECT count(id) FROM order_history oh 
    WHERE oh.refund_of = oh1.id
) "refunds"
FROM order_history oh1 
WHERE `object_name` 
NOT LIKE '%refund%'

I need to translate this into eloquent hopefully without using Db::raw

Add your database structure

Sushant Yadav
– Sushant Yadav

2016-04-13 07:17:03 +00:00
Commented Apr 13, 2016 at 7:17 — Sushant Yadav
– Sushant Yadav, Commented Apr 13, 2016 at 7:17

Joost · Accepted Answer · 2016-04-13 07:50:19Z

1

You should be able to add a sub select query with the method select() or addSelect() as shown here.

Example:

select(DB::raw(count(id) FROM order_history oh WHERE oh.refund_of = oh1.id))

Note: "These expressions will be injected into the query as strings, so be careful not to create any SQL injection points!"

answered Apr 13, 2016 at 7:50

Joost

7617 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Laravel Eloquent setting up a subquery in the select part of the SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related