MySQL Query Question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,
I need some help from you MySQL gurus out there. This is pure SQL by the
way..no front-end.


Lets say you have a table that has 2columns.....columnA,
ColumnB and columnC
I have something like this

 if (columnA>'7', (columnB/columnC)  + 52, columnB/ColumnC) as "Number"

however i need to test if columnc is 0 also cause if i need divide by zero i
get a null value

I cant figure out how to do this any help would be greatly appreciated


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux