Table: kx_kq_store, field: address

{
"Latitude" : "22.62404947916667",
"Longitude" : "114.15052761501737",
"Address", "guangdong province shenzhen longgang district lixin road near the Dan bamboo head round mound district",
"The exception" : "0"
}

CodePudding user response:

Write directly the where to go ~ efficiency according to the index,
Such as: I want to SELECT the address field in the key data for the exception is not equal to zero, the SQL for the SELECT * FROM table_name WHERE address - & gt;> 'exception'!='0'

CodePudding user response:

Use - & gt;> Directly to retrieve the value from the json text type value

CodePudding user response:

@ & gt; To play the role of the index