Help me to create more Dynamic MySQL

Job ID: 31474135

Budget: $10 – $30 USD

Hello, i have a DB almost completed. I can provide the DB schema.
What i want is to have a measure variable like
Id:1 measure variable : temperature
And then set Limit_min and Limit_max and check if the value is within range. If yes, update other table boolean to 1, else, update to 0.

PM me for details.