I have table with very similar values in one field, count word ----- ---- 2 APPLE 6 APPLES 1 APPEL
select *,sum(count) as total from table group by word will leave these rows separated.
So I want to GROUP BY that field to add the numbers (to come up with 9 APPLES). Is this possible? I guess I'm searching for some type of functionality similar to SOUNDEX(), except for grouping not selecting.
Thanks, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
