Yes, It's pretty obvious now. Thank you all for the help.
Mattias Håkansson
----- Original Message -----
From: "Gabriel PREDA" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, April 05, 2005 12:15 PM
Subject: Re: Weird Query Result
> Not weird at all...
> As you can see it returnet all rows where "iImo" equals 0... that is
becuase
> of the CAST applied...
>
> iImo is int(11) thus MySQL is casting 'FOOBAR' and the result is 0.
>
> Try:
> mysql> SELECT CAST('FOOBAR' AS UNSIGNED);
>
> MySQL will yell:
> +--------------------------------------+
> | CAST('FOOBAR' AS UNSIGNED) |
> +--------------------------------------+
> | 0 |
> +--------------------------------------+
> 1 row in set (0.03 sec)
>
> I hope this is clear !
>
> Gabriel PREDA
> www.amr.ro
> www.lgassociations.info
> dev.falr.ro
>
>
>
> ----- Original Message -----
> From: "Mattias Håkansson" <[EMAIL PROTECTED]>
> To: <mysql@lists.mysql.com>
> Sent: Tuesday, April 05, 2005 12:19 PM
> Subject: Weird Query Result
>
>
> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
