Find Jobs
Hire Freelancers

MySQL Database Query Work - Need to parse some data and make usable

$10-30 USD

Cancelled
Posted almost 9 years ago

$10-30 USD

Paid on delivery
We need someone to pull info off our MySQL database and rework it to be more usable. More specifically, we need to do the following: In a MySQL database we have a meta_key called: "score_record" and a meta_key called: "act_score_record". The "meta_value" of each of these rows looks something like this: "a:3:{i:0;a:9:{s:8:"engscore";s:2:"26";s:9:"engmissed";s:1:"4";s:9:"mathscore";s:2:"21";s:10:"mathmissed";s:2:"11";s:8:"sciscore";s:2:"21";s:9:"scimissed";s:1:"7";s:9:"readscore";s:2:"24";s:10:"readmissed";s:2:"10";s:4:"date";i:1424446035;}i:1;a:9:{s:8:"engscore";s:2:"32";s:9:"engmissed";s:1:"3";s:9:"mathscore";s:2:"24";s:10:"mathmissed";s:2:"14";s:8:"sciscore";s:2:"22";s:9:"scimissed";s:2:"10";s:9:"readscore";s:2:"23";s:10:"readmissed";s:2:"10";s:4:"date";i:1425159028;}i:2;a:9:{s:8:"engscore";s:2:"28";s:9:"engmissed";s:1:"3";s:9:"mathscore";s:2:"20";s:10:"mathmissed";s:2:"15";s:8:"sciscore";s:2:"21";s:9:"scimissed";s:2:"12";s:9:"readscore";s:2:"28";s:10:"readmissed";s:2:"10";s:4:"date";i:1428878101;}}" The data in here are practice test scores from multiple attempts at the same test. You can see in the quotes '"mathscore"' and then the next quoted item is '"24"', meaning on that test the person got a 24 on the math section. For each of these rows need to find the lowest score and the highest score someone got on the tests in each section. In this example it appears the lowest math score was 20, the highest 24. We need this for each section on each user. We will then use this info to determine average score changes within our data.
Project ID: 8143688

About the project

9 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
9 freelancers are bidding on average $29 USD for this job
User Avatar
Hello! My name is Vladyslav, and I have 5 years experience in web development! Would be glad to work with you!
$30 USD in 1 day
5.0 (18 reviews)
6.9
6.9
User Avatar
Hello. As far is I understand, you wish to create separate fields int he table to make it more search friendly. I am ready to do this now. Thanks. Eugene
$29 USD in 0 day
4.9 (283 reviews)
6.8
6.8
User Avatar
can do it ealiy , will be done in 2 hour or before that.......................................................................... thanks, gaurav
$25 USD in 1 day
5.0 (105 reviews)
5.8
5.8
User Avatar
I've been working with DBs for 14 years, including MySQL, as a programmer, performance tuner, and DBA. I could easily do this job quickly.
$30 USD in 2 days
5.0 (50 reviews)
5.8
5.8
User Avatar
Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. Could you please send sample data in txt file.. SO that I can make query and show you working solution I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan
$20 USD in 1 day
4.7 (28 reviews)
5.7
5.7
User Avatar
Hi, I am able to parse the data stored in database as per your need. Please discuss with me for your requirement once and I will surely complete this task as per your expectation. Thanks.
$15 USD in 2 days
5.0 (12 reviews)
3.7
3.7
User Avatar
Hi sir, I can create a small php function that fetches data from db, converts it to array and write to db. It would take about 1-2 hours. Thanks, Sean.
$50 USD in 1 day
5.0 (3 reviews)
3.0
3.0
User Avatar
Hi there, Myself Jorden, I have been in web industry since last 7 years and having huge experience over progrmming and managing the project. I can pull off there information. Do let me know if you would like to make a move on this so we can discuss. Regards, UkWebWorld
$30 USD in 0 day
5.0 (10 reviews)
2.6
2.6
User Avatar
A proposal has not yet been provided
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of EL SALVADOR
Santa Tecla, El Salvador
5.0
33
Payment method verified
Member since Jan 21, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.