mysql> select count from csresult where sig = '024b1680d57f61df3b3236f0c9321ce7'; +-------+ | count | +-------+ | -1 | +-------+ 1 row in set (0.00 sec) mysql> show create table csresult\G *************************** 1. row *************************** Table: csresult Create Table: CREATE TABLE `csresult` ( `sig` varchar(32) NOT NULL default '', `count` int(10) default NULL, `results` mediumblob, `extrainfo` text, PRIMARY KEY (`sig`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.01 sec) mysql> show indexes from csresult\G *************************** 1. row *************************** Table: csresult Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: sig Collation: A Cardinality: 204 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: 1 row in set (0.00 sec) mysql> select version(); +------------+ | version() | +------------+ | 4.1.16-log | +------------+ 1 row in set (0.00 sec)