How to get all messages with me and marge, when receiver_id is my_id OR sender_id is my_id

user_13235802 0
Viewed 27

I want to receive all my messages where sender_id is my_id or receiver_id is my id. I receive them but cannot recover them assembled. An example is shown in the picture, how to put all the messages together?

Maybe i can get this data with LARAVEL?

WITHOUT GROUP BY

SELECT sender_id,receiver_id,message FROM messages WHERE sender_id= 1 OR receiver_id= 1

WITH GROUP BY

SELECT sender_id,receiver_id,message FROM messages WHERE sender_id= 1 OR receiver_id= 1 GROUP BY sender_id

laravel sql
1 Answers

Suppose your Model name is Message then you can do it like this:

Message::where('sender_id', 1)->orWhere('receiver_id', 1)->get();
user_77525830
Related