mysql - Convert Fahrenheit temperature value to Celsius with SQL

In my device_events table I have a sensor column which contains an array of sensor data. I have specifically pulled temperature from this array, however temperate is captured in our system as Fahre

mysql - Convert Fahrenheit temperature value to Celsius with SQL Query - Stack Overflow

mysql - Convert Fahrenheit temperature value to Celsius with SQL Query - Stack Overflow