On Friday, February 25, 2005 15:05, Asad Habib wrote: > I am trying to use GROUP BY with a field of type text that is set to > NOT NULL by default. However, in practice this field does not always > contain a string for every record and defaults to the empty string in > this case. When I try to use GROUP BY with this field in a SELECT > statement, only 1 record is retrieved. Anyone experience a similar > problem? Your help would be greatly appreciated. Thanks.
This should only happen if the values in the column you are grouping by are the same for every row that would be returned without the GROUP BY. Without knowing your query and some of the data in your table, I can't really tell you anything else. -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
