Re: MySQL Query Question

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, 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