Mysql5.7 json field filtering problem-CodePudding

 
Database corresponding field, dataFlow is stored at the bottom of the data 
{
"HostName" : "TBD", 
"SqlParse" : [{
"SqlTpye" : "Select", 
"OperateType" : "Table" 
}, {
"SqlTpye" : "Delete", 
"OperateType" : "Table" 
}] 
}

If I want to query contains sqlType is the select data where should be how to write?
If the storage is the json data I will also write
But this object contains an array, meng made the don't know how to write the

I tried the where dataFlow - & gt; '$. SqlParse [0]. SqlType'="Select" can be found out but must be fixed is which one, can you put the other [0] into what can be found out

CodePudding user response:

LIKE query directly, can?

CodePudding user response:

Where the dataFlow - & gt; '$. SqlParse [*] sqlType'="Select"

This is ok