>>>>> "Benjamin" == Benjamin Pflugmann <philemon@stripped> writes:
Benjamin> Hi.
Benjamin> When comparing a varchar with an integer, MySQL compares them as
Benjamin> integers, wich means that it has to convert your varchar to integer,
Benjamin> which - of course - prevents the use of any index on that varchar
Benjamin> column.
Right! This is however fixed in MySQL 3.23.2.
Benjamin> On Sun, Aug 08, 1999 at 03:35:47PM +0200, tony@stripped wrote:
Benjamin> [...]
>> The IDs are all 13 digit numbers, starting 7x000000 ... where x differentiates
> the
>> type of item. Does this mean that MySQL isn't very good at dealing with this if
>> it's referred to in numeric context, but is fine when treated as a string?
Benjamin> [...]
Regards,
Monty
