Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Alternative for MAX operator on bit fields

Tags:

I have table with permissions that has few bit fields. I want to group rows in this table and get result with top permissions. So with this table:

UserId, Permisssion1,Permission2, Permisssion3  

With this to rows
13,1,0,0
13,0,1,0

I want to get:
13,1,1,0

Problem is that operator MAX doesn't works on bit fields. How to do that in efficient way? (without using CASE)

like image 345
Marek Kwiendacz Avatar asked Jan 31 '12 09:01

Marek Kwiendacz


1 Answers

As simple as...

MAX(CAST(Permisssion1 AS tinyint)) 

You don't have many other options...

like image 96
gbn Avatar answered Sep 21 '22 18:09

gbn