After you execute your select/limit statement you can execute
select found_rows()
It returns the number of rows thbat the previous query would have returned
if the limit wasn't applied. See: http://dev.mysql.com/doc/mysql/en/information-functions.html.
Regards,
E
Hi everyone, Im
Stuart,
Comparing anything to null, including another null, will always return
false. This is why you query is returning no results when the clauses that
reference columns that contain nulls are included.
Regards,
Eric
Stuart Felenstein [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
How about adding another column that stores the day of year for the
birthday. You could then index on this column and your query would be for
11/7 would be
doycol=DAYOFYEAR(2004-11-07)
or
doycol=312
E
Jigal van Hemert [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have date of