Re: Strict Matching For Selects

[Ramalingam Chelliah]

Hi,
For integer fields evenif you give a string after it it won't consider it...
For string to integer conversion is done automatically ....


mysql> select 1+'11a';
+---------+
| 1+'11a' |
+---------+
| 12 |
+---------+
1 row in set (0.00 sec)

'11a' is taken as 11

mysql> select 1+'a11';

+---------+
| 1+'a11' |
+---------+
| 1 |
+---------+
1 row in set (0.00 sec)

'a11' is taken as 0

Refer:
http://dev.mysql.com/doc/mysql/en/Cast_Functions.html

Hope this helps,

Regards,
Ram.

We Learn the Most When we have to Invent