Union operator in laravel eloquent

Question

How can I use sql UNION operator in eloquent ORM? I know I can use it in Illuminate\Database\Query\Builder , but I want to do it with eloquent. I couldn't find anything about it in documentation neither in google. is it possible to do it?

Eloquent ORM doesn't have `union` method. Please describe what exactly you want to do. — Alexey Mezenin, Dec 27 '17 at 13:39
Possible duplicate of [Laravel Eloquent Union query](https://stackoverflow.com/questions/41756404/laravel-eloquent-union-query) — ndrwnaguib, Dec 27 '17 at 13:43
I'm trying to union multiple(two) queries, I dont want to send 2 quires — devnull Ψ, Dec 27 '17 at 13:45
You could combine two eloquent collections but it doesnt have union method — Luis felipe De jesus Munoz, Dec 27 '17 at 13:46
@devnull what's wrong with sending two queries to get two collections (nested or separate)? — Alexey Mezenin, Dec 27 '17 at 13:53
I'm trying to do simple thing and that's why don't want to send 2 queries, also I need relations and mutators, thats why I don't choose `querybuilder`, but as I see I will have to send 2 queries — devnull Ψ, Dec 27 '17 at 13:56
Forget about how many queries you send. Eloquent uses a lot of queries when getting data so... — Luis felipe De jesus Munoz, Dec 27 '17 at 14:07

devnull Ψ · Accepted Answer · 2019-09-10T11:24:23.027

2

you can use union() method in eloquent in the same way as its in Illuminate\Database\Query\Builder

docs

edited Sep 10 '19 at 11:24

answered Apr 20 '18 at 13:17

devnull Ψ

3,779
7
26
43

Union operator in laravel eloquent

1 Answers1