Bitwise OR among results

Question

I'm wondering if it's possible to do a bitwise OR among MySQL query. I have a query like:

SELECT `value` FROM `table` WHERE `code`='4'

It returns an array of values, but I want a unique value with the bitwise OR of all values. Is is possible from MySQL or should I delegate to PHP?

I.e. The query above returns this list of values:

value
-----
1
5
4
2
7
8

And I want as a result the OR of these values 1 | 5 | 4 | 2 | 7 | 8 = 15

Duplicate or similar to: http://stackoverflow.com/questions/1397913/is-it-possible-to-perform-a-bitwise-group-function — Jim H., Nov 09 '11 at 16:22

lqez · Accepted Answer · 2011-11-09T16:31:30.730

6

SELECT MAX(@r:=@r|value) FROM `table`, (SELECT @r:=0) x

Jim.H's suggestion is much better. Thanks!

SELECT BIT_OR(value) FROM `table`

edited Nov 09 '11 at 16:31

answered Nov 09 '11 at 16:24

lqez

2,898
5
25
55

2

Clever, but eww. `SELECT bit_or(value) FROM table;` – Jim H. Nov 09 '11 at 16:28

Bitwise OR among results

1 Answers1