This question probably should be posted to the MySql mailing list but here goes.
Take a look at this link:

Your example was not very explicit so I am not sure, but I believe you are in need of a
WHERE clause. For example;

Select a, b, c where a >7 and c <> 0

This should get you going in the right direction.

At 03:29 PM 1/23/03 -0600, Jeremy wrote:
I need some help from you MySQL gurus out there. This is pure SQL by the 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 (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to