----- Original Message ----- From: <[EMAIL PROTECTED]> To: "DL Neil" <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 1:05 PM Subject: Re: Re: Select and count duplicates
> Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Michelle, > > > I have a column containing headlines. In this column > > there are some duplicates, like this: > > ----------- > > monsters > > headline1 > > monsters > > halloween > > monsters > > halloween > > ... > > ---------- > > > > How can I get a result like this instead? > > HEADLINE | HITS > > ----------------------- > > monsters | 3 > > halloween | 2 > > headline1 | 1 > > ----------------------- > > > > Any thoughts? > > > GROUP BY headline and COUNT() > =dn > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php