Home > database >  Mysql json array query conditions
Mysql json array query conditions

Time:11-25

If a field is a json type, format the following
[{" starttime ": 1," closetime ": 2," duration ": 1}, {" starttime" : 3, "closetime" : 5, "duration" : 2}]

Query condition that contains at least one element starttime> 1 and duration> 2, pay attention to is to require an element at the same time satisfy the two conditions,
  • Related