COUNT(*) faster?

[Steve Buehler]

I am using PHP & MySQL for a program that I am writing.  I have a table in 
my database that has a column with dates in it in the form 
yyyy-mm-dd.  Sometimes there is nothing in the table with the search date 
that I am using.  Other times there might be 1000's of rows with that in 
the date column.  I am trying to find out if there are any rows with the 
date that I am searching for in the 'date' column.  Would the fastest way 
be to use
$date=2003-02-16;
SELECT COUNT(*) FROM `games` WHERE `date`='$date'
or is there a faster way?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]