Techiio-author
Started by Bradley ReidOct 31, 2021

Open
Find all records by the value of the json key in MySQL

0 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWES SHARE

I've mysql (mariadb 10.1. - I can not use Json functions - Json_Extract and so forth.).

In the database I've a desk contracts and a column statistics, which includes Json (facts kind text):

"879": "take a look at", "880": "15255", "881": "2021-10-22"

And I want to locate all records that have a key price of "880" in a few range, eg more than 10000 and much less than 20000, ie. In this case, a document with a cost of 15255.

0 Replies

You must be Logged in to reply
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance