Simplying a few MySQL Queries - Help Needed

Originally Posted by MarcoH64

if the value of ispending is '1', it will result in a value of 1, otherwise 0 (zero), if you then sum it, you will count 1 for each row that have ispending = 1.

By testing ispending = 0, you can reverse the count.

Thanks Marco

[AN-net]

can IF be used within the parameters of where?

[Marco van Herwaarden]

That wouldn't make much sense i think, the where clause is already 1 big if-statement, but i never tried.

more info: http://dev.mysql.com/doc/refman/5.0/...functions.html

[high]* Guest190829 clicks link
[/high]

There's so much stuff I haven't even learned yet, Ah! Thanks again Marco.

[AN-net]

i was asking because of this:
https://vborg.vbsupport.ru/showthread.php?t=94088