how to select rows that has only one condition

[fire eaters]

This is how my license table look like.. i want to select only row that has atleast one "1".
which means i don't want to select any row that has full of zeros..

[pritaeas]

Use a calculated column that sums all your 0/1 columns. Then you can just add WHERE summed > 0

[fire eaters]

Use a calculated column that sums all your 0/1 columns. Then you can just add WHERE summed > 0

you mean a calculated colum as an alias right. give me an idea to summ all 0/1..

[pritaeas]

SUM(column1, column2, ...) or just column1 + column2 + ...

[fire eaters]

SUM(column1, column2, ...) or just column1 + column2 + ...

SELECT 
sum(F1)+sum(F2)+sum(F3)+sum(F4)+sum(F5)+sum(F6)+sum(F7)+sum(F8)+
sum(A)+sum(A1)+sum(B)+sum(B1)+sum(B2)+sum(C)+sum(C1)+sum(C2)+sum(V1)
as total
FROM `licence` 
WHERE total> 0

the error says unknown column total. my idea is to select rows that atleast have one "1"

[pritaeas]

SELECT *
FROM `licence` 
WHERE F1+F2+F3+F4+F5+F6+F7+F8+A+A1+B+B1+B2+C+C1+C2+V1 > 0