I am getting problem while retrieving records from mysql table with where clause

[imranlink]

I am getting problem while retrieving records from mysql table with where clause query.

SELECT * FROM `products` where `cost`=2.01

does not show any record.
Please help me to find out where is the problem.
why the above query does not get the record ?

My table Structure with one record.

CREATE TABLE `products` (
  `part_num` varchar(15) NOT NULL default '',
  `cost` float(10,2) default '0.00',
  PRIMARY KEY  (`part_num`)
) TYPE=MyISAM;

INSERT INTO `products` VALUES("HP001", "2.01");

Regards,
Muhammad Imran Khalid
http://imran.phptrack.com
Cell : +92.345.6900444

[rincewind456]

I think you'll find it's to do with the fact your using float as the storage type see here for an explanation.

You would be better served using the decimal field type as it stores exact representations of the value.