KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have the following (MySQL) table called "tweets": tweet_id created_at --------------------- 1 1298027046 2 1298027100 5 1298477008 I want MySQL returning the number of tweets per day of the week; taking the above data it should return: Wednesday 1 Friday 2 I now have the following query (which should return the day of the week index, not the full name): SELECT COUNT(`tweet_id`), WEEKDAY(FROM_UNIXTIME(`created_at`)) FROM tweets2 ORDER BY WEEKDAY(FROM_UNIXTIME(`created_at`)) This however returns: COUNT(`tweet_id`) WEEKDAY(FROM_UNIXTIME(`created_at`)) 7377 4 (There are a total of 7377 tweets in the database). What am I doing wrong?
Tags (comma-separated)
Save Edits
Cancel