> I'm stlll surprised that NAME = 2 returns anything. When I tried your > example, it returned no rows. I get two rows with NAME = 0, nothing > with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake. > NAME = 0 is a string-to-number conversion. MySQL converts the string > to a number and performs a numeric comparison. Of your three values, > 'ppl1' and 'ppl2' will be converted to 0 (which compares the same as 0), > but NULL is still NULL (which does not compare the same as 0). Ok, i understand now. This is useful when you have things like '10' or '342'. But when you have 'ppl1' isn't deterministic wich number it represent. But thanks. I'm studying to understand how MySql works. I have another question, will open another thread to it. Thanks. --------------------------------------------------------------------- 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
