Category: MySQL

Condition based MySQL left join with CASE

Happy to write post after long time 🙂 I had a scenario that there is are some fields in a table like `id`,`group`,`object_id`. `group` field(ENUM) has three groups named `user`, `deal`, `scene` and `object_id`(it will have the primary key for corresponding group). ie., If the row has group name of `user`, then `object_id` refers to […]

Read More…