make an addition

[nomad9]

Hi all!

don't know if it's possible ..... can we just addition, substract or even multiply value in mysql db with a statement like this :

select Value from tablename where Status = 1

so if Value is equal to row1=90 row2=78 and row3=22 ... then i'll get 190

Thank

Steve

[cgraz]

SELECT (row1 + row2 + row3) AS sum WHERE Stats='1';

Changed Status to Stats, because I believe Status is a reserved word.

Cgraz

[nomad9]

cool thank alot 😉