sqlite - Checking at least two columns SQLite3 -


i have table, has 5 boolean columns, few other columns, so:

rowid | bool1 | bool2 | bool3 | bool4 | bool5 | other1 | other2 | other3 |     1 |     1 |     1 |     0 |     0 |     0 |      5 |     34 |  'foo' |     2 |     0 |     1 |     0 |     1 |     0 |      7 |     42 |  'bar' |     3 |     1 |     1 |     1 |     1 |     1 |     12 |      7 | 'blah' |     4 |     0 |     1 |     0 |     0 |     0 |      5 |     34 | 'blah' | 

i want way select rows in @ least 2 of bool columns true. in case: rows 1, 2 , 3 not 4.

any suggestions?


Comments