Find Jobs
Hire Freelancers

MySQL CLI for Search data with JSON stored data

$10-30 USD

Closed
Posted over 3 years ago

$10-30 USD

Paid on delivery
Hello, I'm using MariaDB 10.4 and i have table name 'users' and stored data as JSON with column name 'event' How i can search by where and get 1 row find by "mtcode" [ { "mtcode": "mtcode-rollout-00037:GC", "amount": 20, "eventtime": "2016-01-02T15:04:05-04:00" }, { "mtcode": "mtcode-rollout-00037:GC", "amount": 20, "eventtime": "2016-01-02T15:04:05-04:00" } ] Exmaple: [login to view URL]
Project ID: 27537994

About the project

8 proposals
Remote project
Active 3 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
8 freelancers are bidding on average $30 USD for this job
User Avatar
Hello, I will update the script to search the JSON stored data in MySQL users table. I will complete this work in a day. Looking for your reply to start this work immediately. I am available online for 10 - 14 hours per day as full-time freelancer.
$25 USD in 1 day
5.0 (1284 reviews)
8.2
8.2
User Avatar
Hello Sir, THis can probably be done using like operation or fetching all record and then search. I am willing to start right away. Please check my profile for work and experience. Regards Hardeep
$35 USD in 1 day
5.0 (371 reviews)
7.1
7.1
User Avatar
Hello, I am a Mysql query expert and i can help you to write query and get the data Kindly ping me for further discussion Thanks
$30 USD in 7 days
5.0 (100 reviews)
6.6
6.6
User Avatar
I can develop you a query to search rows by values which stored in JSON column. I am SQL expert wit more that ten years of experience.
$35 USD in 1 day
5.0 (38 reviews)
5.2
5.2
User Avatar
Hello There, I have checked and understood your requirement and I can make query for you for find data from JSON in MySql query. If you have any question please feel free to ask I will be happy to assist you. Looking forward to working with you on your Valued Project. Regards, Sanjay Parmar.
$30 USD in 1 day
5.0 (21 reviews)
4.6
4.6
User Avatar
hello sir, i read you description. i am work on database management with mysql CLI last 6 year. i highly interested in your task. I'll give satisfied query for your task. other discuss on chat and yes please don't go on my profile because it's now start. thank you
$35 USD in 2 days
5.0 (7 reviews)
3.2
3.2
User Avatar
Hi there, Although I am new to freelancer.com but have enough experience. I have handled Databases and backend for many freelancers and startups. I have enough experience to work on this. I can solve this in just half an hour. Kindly consider this proposal for me. I will deliver on time with utmost optimized code. Thank You
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, You need use JSON_EXTRACT in sql ==> add it to object. You can search data in that object. Thank you!
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of THAILAND
Bangkok, Thailand
0.0
0
Member since Sep 28, 2020

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.