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


Taidot: Tietokannan hallinto, Tietokantaohjelmointi, MySQL

Näytä lisää: 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

Tietoa työnantajasta:
( 5 arvostelua ) croydon, United Kingdom

Projektin tunnus: #19794429

Myönnetty käyttäjälle:


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 Lisää

£20 GBP 0 päivässä
(8 Arvostelua)

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

£15 GBP 7 päivässä
(49 arvostelua)

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 Lisää

£18 GBP 1 päivässä
(26 arvostelua)

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 Lisää

£20 GBP 7 päivässä
(17 arvostelua)

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 Lisää

£15 GBP 7 päivässä
(33 arvostelua)

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 Lisää

£30 GBP 1 päivässä
(18 arvostelua)

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 Lisää

£15 GBP 1 päivässä
(6 arvostelua)

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 7 päivässä
(4 arvostelua)

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 Lisää

£10 GBP 1 päivässä
(6 arvostelua)

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 Lisää

£18 GBP 1 päivässä
(8 arvostelua)

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 7 päivässä
(1 arvostelu)

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 Lisää

£10 GBP 1 päivässä
(3 arvostelua)

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 1 päivässä
(3 arvostelua)

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 Lisää

£10 GBP 1 päivässä
(3 arvostelua)

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

£18 GBP 1 päivässä
(0 arvostelua)