selecting where json field in a json type column in MySQL
Trying to select rows where a field in a json value is equal to whatever, and somewhat struggling.
query so far, and example of the data stored in the json field
Trying to query a json field and struggling to quite get the results in MySQL.
This is the query I have so far, and whilst there is a row in the database that has this specific ID, i can't get it right, and the docs aren't quite sinking in
field/json is formated as (just the relevant part) (generated using json_encode($data))
1 Reply
Solved via an incorrect encoding type on saving the data to the database