Hello, I'm using MySQL 4.0.20 on Linux and I am experiencing some problems with a query result.
I have the following table structure: mysql> desc gen_Lloyds_vessel; +-----------------+----------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+----------+------+-----+---------------------+----------------+ | iLloydsvesselID | int(11) | | PRI | NULL | auto_increment | | cName | char(50) | | | | | | iImo | int(11) | | | 0 | | | cCountry | char(5) | | | | | | iYearbuilt | int(11) | | | 0 | | | cVesseltype | char(40) | | | | | | iEnteredby | int(11) | | | 0 | | | tEntered | datetime | | | 0000-00-00 00:00:00 | | | iUpdatedby | int(11) | | | 0 | | | tUpdated | datetime | | | 0000-00-00 00:00:00 | | +-----------------+----------+------+-----+---------------------+----------------+ 10 rows in set (0.00 sec) Look at the query below: mysql> SELECT cName,iImo FROM gen_Lloyds_vessel WHERE gen_Lloyds_vessel.iImo = 'FOOBAR'; +----------------------+------+ | cName | iImo | +----------------------+------+ | SSG EDWARD A. CARTER | 0 | | LYKES HERO | 0 | | PONL GENOA | 0 | | YM MILANO | 0 | | PONL NEWARK | 0 | | COSCO NORFOLK | 0 | | PONL JAKARTA | 0 | | PONL SYDNEY | 0 | | PONL GENOA | 0 | | PONL MARSEILLE | 0 | +----------------------+------+ 10 rows in set (0.07 sec) None of these iImo fields has the value 'FOOBAR' but still I receive these results. Anyone have a clue what is causing this? Thank you for your time, Mattias Håkansson
