xxxxxxxxxx
//column // type STRING
+---------------------------------+
| column |
+---------------------------------+
| {"size": 42, "colour": "white"} |
| {"size": 18, "colour": "black"} |
+---------------------------------+
$sql = "SELECT JSON_EXTRACT(column, '$') AS json FROM tablename";
$result = $conn->query($sql);
//output: json = // type OBJECT
while($row = $result->fetch_assoc()) {
echo $row["column"]->size;
}