MySQL CLI for Search data with JSON stored data

$10-30 USD

Zaprt

Objavljeno

pred več kot 3 leti

$10-30 USD

Plačilo ob dostavi

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]

MySQL

PHP

Linux

Software Architecture

Database Administration

ID projekta: 27537994

Več o projektu

8 ponudb

Projekt na daljavo

Aktivno pred 4 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

8 freelancerjev je oddalo ponudbo s povprečno vrednostjo $30 USD za to delo

@sureshdevi

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 v 1 dnevu

5,0

(1284 ocen)

8,2

@nixtech

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 v 1 dnevu

5,0

(371 ocen)

7,1

@goodwork20k

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 v 7 dneh

5,0

(100 ocen)

6,6

@SqlDevelopment

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 v 1 dnevu

5,0

(38 ocen)

5,2

@sanjay1450

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 v 1 dnevu

5,0

(21 ocen)

4,6

@dixitrajpurohit

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 v 2 dneh

5,0

(7 ocen)

3,2

@priyaprerna

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 v 7 dneh