MySQL Forums
Forum List  »  Newbie

Re: Strict Matching For Selects
Posted by: Ramalingam Chelliah
Date: August 31, 2004 03:43AM

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


Hope this helps,


We Learn the Most When we have to Invent

Options: ReplyQuote

Written By
August 30, 2004 06:30PM
Re: Strict Matching For Selects
August 31, 2004 03:43AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.