assistance with mysql query

I need to advance this query below to group by date (day) using a join of the 'taken_at_timestamp' column from the table media ( the timestamps are stored as varchar so think you need to use UNIX_TIMESTAMP somewhere

SELECT caption_mentions,

count(*) as count FROM mentions

WHERE caption_mentions ='london_dad'

GROUP by caption_mentions


Skills: Database Administration, Database Programming, MySQL

See more: help with sql server, mysql tutorial, mysql help online, mysql help forum, sql live help, mysql help command line, coding help, developers help, edit csv mysql query, asp mysql query, 2013 lost connection mysql query, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query, optimize mysql query software, mysql query php table css, php mysql query format table, mysql query search

About the Employer:
( 4 reviews ) croydon, United Kingdom

Project ID: #19794429

Awarded to:


Hello. I looked carefully at your posts. mysql database manage & programming is my best work. also i have a enough history in this part. If you have the opportunity to talk to me, I think I can create a less cost e More

£20 GBP in 0 days
(8 Reviews)

16 freelancers are bidding on average £17 for this job


Hi . I am very interested in your project. I have 7 years of web development experience such this projects. If you have good idea, I will do make your idea perfectly and at a short time. Hope to discuss more detail. L More

£15 GBP in 7 days
(49 Reviews)

Hello Sir/Mam, MAKSOF is a team of highly qualified professionals who is dedicated in providing creative solutions and innovative ideas for your business with our skills in technologies and strategies. We have r More

£18 GBP in 1 day
(24 Reviews)

Hello!! I am mysql query Developer having more then 5 years experience in mysql query development. Skills: JavaScript, PHP, WordPress, HTML5/CSS3/Bootstrap3, Jquery, MySql I would like to arrange an interview with y More

£20 GBP in 7 days
(17 Reviews)

Hi. I've read carefully your job description I'm have a lot of experiences in JAVA, C++, VB, DATABASE ,SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will More

£15 GBP in 7 days
(30 Reviews)

Dear Sir. I am interested in your project. I'm senior Laravel, PHP, SQL, Javascript developer. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your custo More

£20 GBP in 1 day
(16 Reviews)

How about it? "SELECT mentions.caption_mentions, count(*) as count FROM mentions Join media [login to view URL] = TIMESTAMP(media.taken_at_timestamp) WHERE caption_mentions ='london_dad' GROUP by mentions.caption_mentio More

£15 GBP in 1 day
(6 Reviews)

Hi, glad to bid on your project. I have read your description. I have skills in db management and programming related to db. I have worked 7+ years in DBMS. I think I am suitable for you to do that quickly and perf More

£30 GBP in 1 day
(7 Reviews)

Hello Just to introduce my self ,I have more than 5+ years of experience in design & development. And as a policy we will provide 3 month maintenance "free of cost" for the project done by us. Now coming on this More

£18 GBP in 1 day
(7 Reviews)

Interesting Wonderful project! We are good team in many experiences in Web developing. We are masters of math and web design. If you keep in touch with us, you can get satisfy result. Thanks a lot!

£30 GBP in 7 days
(1 Review)

Hello How are you? I am expert in website design and development and i can handle this project. Give me one chance to work with you.... Ready to start your project right now. Thanks sumit chawla

£15 GBP in 7 days
(4 Reviews)

Hi Thanks for the opportunity to place bid on this project. I carefully read the comments and thought about the points to consider in the project. There are many sql database development experiences. I think I can More

£10 GBP in 1 day
(3 Reviews)

dear. I am Valentin.S in Russia. I am expert in mysql query I can help you as well very fast thank you

£15 GBP in 1 day
(3 Reviews)

Hi I am experience software engineer. I possess strong knowledge in SQL, PL-SQL with MySQL, SQL Server and Oracle databases. I have delivered projects in time and within budget. I am the best fit for your task. Award m More

£10 GBP in 1 day
(3 Reviews)

Hello.I am a Web developer. I am interesting on your project and I have 6+ yeasr of experience of working MySql I can implement your project with fully and completely. I can help you with my best. Thanks for your p More

£10 GBP in 1 day
(1 Review)

I have more then 15 years of experience in DBMS and immediately available

£18 GBP in 1 day
(0 Reviews)