Please excuse me if this is not the correct place to post this question. I am fairly new to working with MySQL. I have two machines that have the same database, each for different development purposes.
There is a table in the database that I regularly query for product info. The table is in set up like this prodID[bigint] name[char20] description[char50] price[float] discount[float] SELECT * FROM products WHERE price>5.00; to get all products with a price greater than $5.00 On one machine it works, but on the other it does not. Instead, it returns all entries in the table. The second machine's database was created by doing a mysqldump from the first one, and then loading that file into the database. Part of the strange thing is that if I run a query like: SELECT * FROM products where prodID>123; It works on both machines. Is there something about float comparisons? Can anyone give me some ideas where the problem might be? Thanks for your help. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
