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"
Exmaple: [login to view URL]
Bu iş için 9 freelancer ortalamada $29 teklif veriyor
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 p Daha Fazla
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
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 Daha Fazla
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.
Hello, You need use JSON_EXTRACT in sql ==> add it to object. You can search data in that object. Thank you!