Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird developer and have to acomplish some tasks using a mysql based database. So i'm looking about how things work in mysql.
My question... i created a table TEST, with two columns, ID_TEST int(11) and NAME varchar(50).. and added three records. This way: 1, "ppl1" 2, "ppl2" 3, <null> ok.. why when i execute this sql, mysql return the two first rows, instead of raising an error? select * from TEST where NAME = 2?? TIA. --------------------------------------------------------------------- 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