mySQL Select
Posted: Fri Feb 27, 2004 12:20 pm
I am wondering if something is possible to do in mysql. I have one row of data in a mysql table and I would like to select all the information that is not equal to zero. I'd imagine there is a way to do this in PHP or mysql, but I am unable to find that.
For example I've got CGoals = 5, CAssists = 3, CPIM = 0, CPlusMinus = 0. I wanna select just CGoals and CAssists. However there will be many different cases where different variables will be different values.
Any help would be appreciated.
For example I've got CGoals = 5, CAssists = 3, CPIM = 0, CPlusMinus = 0. I wanna select just CGoals and CAssists. However there will be many different cases where different variables will be different values.
Any help would be appreciated.