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, 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:
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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
