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,
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]
To:
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',