How to get specific columns based on different Enum types in Mysql query?
I have a Enum column – for example: deviceType; in a table with 8 different values for the enum. How to get columns – for example – imeiId and macId; based on the values. For example, get ImeiId based on 4 enum values, and get MacId based on other 4 enum values. Note: All columns … Read more