Micro project Parsing a JSON String in mysql and creating totals for the different variables inside
$10-30 CAD
着払い
There are columns are other columns involved but here is the one that i need parsed
[{"id":3099,"type":"dp","character":"74523"},{"id":3099,"type":"dp","character":"74523"},{"id":3099,"type":"dp","character":"74523"},{"id":3099,"type":"dp","character":"74523"}]
Sample of the strings involved this would need to be grouped like this
ID COUNT
3099 x
I would also need one a 2 more queries of this nature grouping by different columns
プロジェクトID: #16162464
プロジェクトについて
12人のフリーランサーが、平均$21 で、この仕事に入札しています。
Hi there, Quick and easy. Just send FTP access. I have a 99% project completion rate and a 4.99 reputation (out of 5.0 from over a thousand projects. Thanks. Regards, Rajesh Soni.
Hello. So it just needs to yield (3099, 4) no matter what `type` and `character` are, and insert it to some mysql table? Thank you.
Hello i am senior php developer with 5+ years experience. I have experience with the php js json ajax and jquery etc..
We understand your requirements and would like to complete this task for you. Kindly get in touch to take this further.
Hello Client, This is an interesting project, I would like to discuss with you more details, please come on chat for more info, I can do the best. skills: Javascript, MySQL, PHP, Json Contact me Thanks
Hello Sir, After going through the job description regarding "Parsing a JSON String in MySQL", I am glad to let you know that I am able to parse and calculate JSON variable values as per your instruction because I h もっと
I have 4+ years of experience with Sql queries and JSON and have worked with Amazon as a database expert. Please review my profile and message me on chat so that we can discuss the finer details of the project.
Deciphering the json format data to get an aggregate level of data is the initial understanding of the project scope.