SELECT * FROM coffees WHERE price = 7.99
on the attached table, and it keeps returning an empty rowset. I am expecting it to return the rowset that looks like:
Colombian 101 7.99 0 0
I've tried running my query on the command line, in a Java, and in a PHP program and all three returned me an empty rowset.
I know that I have a connection to the appropriate database and the server. Any ideas as to why this isn't returning what I want it too?
This post has been edited by chili5: 15 February 2009 - 11:48 AM