MySQL Query Question
| From: | Jeremy | Date: | Thu, 23 Jan 2003 21:29:17 +0000 |
| Subject: | MySQL Query Question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25084@lists.php.net to get a copy of this message | ||
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