Here’s my table schema:
In the above test table I want to group my records by user_by and message_type only when the message_type = "push_message".
I am trying to achieve it without any sub query, suggestions please.
I tried this
SELECT * FROM `test` group by (CASE WHEN message_type = 'push_message' THEN user_by ELSE id END);
But throws an error in MySQL.
Thank you for your responses. After some more research I got it right.
SELECT id, user_id, user_by, message_type FROM test GROUP BY IF(message_type = 'push_message', concat(user_by, message_type), id);
Answered By – Jitender Yadav
Answer Checked By – Terry (BugsFixing Volunteer)