It would help if you could provide more details. For example, what do you mean by "large gaps"? Do you mean there are rows which match the WHERE condition whose Date values don't show up? An example would be good. What does EXPLAIN say for your query?
Michael
James Purser wrote:
I have a large database that I am trying to run a SELECT DISTINCT
across.
SELECT DISTINCT Date FROM tb_spots WHERE aired_station = '??'
However the results I am getting from this query do not match up with the data on the database, instead there are large gaps.
Is there any know problem with SELECT DISTINCT across large databases?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]