Messwert aus String extrahieren

[Thoralf Brandt]

Hallo, ich bin neu im Forum und habe eine Frage. Ich frage die MySQL Datenbank so ab:
SELECT DISTINCT concat (value) FROM mqtt
WHERE topic LIKE 'Sens/005/pulse/SENSOR' AND date(ts)=curdate()
ORDER BY ts DESC

Ergibt:
{"Time":"2021-06-02T13:15:10","AM2301":{"Temperature":26.7,"Humidity":40.6,"DewPoint":12.2},"ESP32":{"Temperature":55.6},"TempUnit":"C"}
{"Time":"2021-06-02T13:10:10","AM2301":{"Temperature":26.7,"Humidity":40.8,"DewPoint":12.3},"ESP32":{"Temperature":55.0},"TempUnit":"C"}
{"Time":"2021-06-02T13:05:10","AM2301":{"Temperature":26.6,"Humidity":41.0,"DewPoint":12.2},"ESP32":{"Temperature":55.6},"TempUnit":"C"}
{"Time":"2021-06-02T13:00:10","AM2301":{"Temperature":26.6,"Humidity":41.3,"DewPoint":12.4},"ESP32":{"Temperature":55.0},"TempUnit":"C"}
{"Time":"2021-06-02T12:55:10","AM2301":{"Temperature":26.6,"Humidity":41.5,"DewPoint":12.4},"ESP32":{"Temperature":55.0},"TempUnit":"C"}
{"Time":"2021-06-02T12:50:10","AM2301":{"Temperature":26.7,"Humidity":41.8,"DewPoint":12.6},"ESP32":{"Temperature":55.0},"TempUnit":"C“}

Ist es in MySQL möglich nur den letzten Wert 26.7 als Temperatur auszugeben (für Grafana)?

Vielen Dank für die Hilfe