> 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
Oh CRAP! You lost me... you said two columns but listed 3! ;)
> if (columnA>'7', (c
It is safe to test if the divisor is zero:
replace
columnB/columnC
by
IF( columnC = 0, 0, columnB/columnC )
(the "0" could be anything else; this depends on your business logic)
Ignatius
- Original Message -
From: "Jeremy" <[EMAIL PROTECTED]
Jeremy,
This question probably should be posted to the MySql mailing list but here
goes.
Take a look at this link:
http://www.mysql.com/doc/en/Where_optimisations.html
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
