I have seen MySQL triggers mentioned and I am curious whether they could be used for my scenario. That being:

lets say i have a table `results_tb`. Currently there is a field `score` and a field `grade` . So can I use triggers to update grade on the event of score changing?

so for example, lets say score stored was 40, the grade is updated to C, then again if the score is updated to 70, the grade is updated to A.

is this possible with triggers?