The opposite of Paul's cast is:
select '4ae'f + 0;
That will show you what MySQL ends up with after casting a string to an integer.
-Eric
On 4/16/05, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 22:18 +0200 4/16/05, Andy Pieters wrote:
> >Hi everone
> >
> >I ran into some situation where MySql sel
At 22:18 +0200 4/16/05, Andy Pieters wrote:
Hi everone
I ran into some situation where MySql selects a row by using the following
query:
SELECT `id` FROM `shop_products` WHERE `id`="4aef" LIMIT 1;
++
| id |
++
| 4 |
++
Granted the field IS of type int but 4 is not identical to 4aef (it
Hi everone
I ran into some situation where MySql selects a row by using the following
query:
SELECT `id` FROM `shop_products` WHERE `id`="4aef" LIMIT 1;
++
| id |
++
| 4 |
++
Granted the field IS of type int but 4 is not identical to 4aef (it may be
equal to the eyes of MySql)
Is
