'How to split a multi value sql column into three single result

So I have a SQL column that stores data like this.

"[1338,0,8523]"

I was wondering if I can then garb each one individually and because the value is minutes, if I could times it by 60 to get the hours and then display it, I've used the below for my other results but I'm stuck on this one.

<?php

$servername = "localhost";
$username = "Time";
$password = "fakepassword";
$dbname = "time";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
     die("Connection failed to Timebase Highscores: " . $conn->connect_error);
}

$sql = "SELECT name, time FROM players ORDER BY time DESC LIMIT 5";
$result = $conn->query($sql);
 
echo "Top 5 Life Wasters". "<br>";
if ($result->num_rows > 0) {
     while($row = $result->fetch_assoc()) {
          echo $row["name"]. " - $" . $row["time"] . "<br>";
     }
} else {
     echo "Error fetching any players from database.";
}
$conn->close();
?>


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source