Anvar Hussain K.M. writes:
> Hi,
> Since the equality test is for a number, the phone_no field of every row of
> the table
> is converted into a number first and tested for the equality. This makes it
> impossible
> to use the character index and so forces the full table scan.
>
> If it were using the index then, I think, it cannot find the intended records .
> This is because if it were the case, the number 0636941 which is in fact
> 636941 should be
> first conveted to string '636941' and the query executed and that is not
> the logical one to
> do.
>
> Anvar.
>
Good answer !
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
