Comparison of major players like AWS, Microsoft Azure, IBM Bluemix, and Google Cloud Platform
Solved
how i can count the number of message REPEATED
Posted on 2012-12-25
i have a table contain a msg field
and the message format is like :
Vote george
vote mbuzo
format of the message is VOTE "NICKNAME"
I WANT TO COUNT THE NUMBER OF MSG FOR EACH NICKNAME ??
and the message format is like :
Vote george
vote mbuzo
format of the message is VOTE "NICKNAME"
I WANT TO COUNT THE NUMBER OF MSG FOR EACH NICKNAME ??
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
3
2- +3
14 Comments
SELECT msg, COUNT(*) AS total FROM <table_name> WHERE LOWER(msg) LIKE 'vote %' GROUP BY msg ORDER BY total DESC;
it's dosen;t work with arabic i have replace the word voting by arabic translated word and no result :S
no points here, you have to use the correct "collate" keyword:
SELECT msg, COUNT(*) AS total
FROM <table_name>
WHERE LOWER(msg) LIKE 'vote %' COLLATE _your_collation_name_goes_here
GROUP BY msg ORDER BY total DESC;
well, I asked you to use COLLATE keyword ...
anyhow, with "arabic" data, I am not 100% sure how this works out, but it should be straightforward ...
anyhow, with "arabic" data, I am not 100% sure how this works out, but it should be straightforward ...
can you show sample , so we could try to reproduce it?
I can only tell you that basically the query suggestion does work ...
I can only tell you that basically the query suggestion does work ...
Active 6 days ago
Try this:
SELECT DISTINCT(REPLACE(message,'Vote ', '')) AS message, COUNT(*) AS votes
FROM _messages
GROUP BY message ORDER BY votes DESC
Featured Post
Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month7 days, 4 hours left to enroll
704 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.