Yours is the first and the winner! :) Thanks using is null worked in the query... Do you know why = doesn't work?
-----Original Message----- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 4:00 PM To: Mysql; Brendin Subject: RE: Problem with query hi. first of many replies, i'm sure: mysql> select count(compid) from dbLastFaxed where lastFaxedDateTime IS null ; when you're looking for NULL fields, select where something IS NULL, instead of '=' -----Original Message----- From: Brendin [mailto:[EMAIL PROTECTED]] Sent: October 26, 2001 5:46 PM To: [EMAIL PROTECTED] Subject: Problem with query I am having a strange problem with a query... I have a table that contains 3 columns and 3,315,599 rows. One of the columns is a date time field. Out of 3,315,599 rows 1,555,157 contain an entry in the date time field and the other 1,760,442 rows contain null in the date time field.... Here is the problem I will illustrate it with queries and results. --------------------------------------------------------------------- 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
