mysql - updating a field on update of other field in same row -

i have table this:

user_level

uid | level_order | current_level --------------------------------- 1   | 1,2,3       | 1 2   | 4,5,6       | 4 3   | 7,8,9       | 7 

now, if update level_order field particular user, want update current_level using trigger or procedure.

for example if run query :
update user_level set level_order = '21,22,23' uid=1;
table should update this:

    uid | level_order | current_level     ---------------------------------     1   | 21,22,23    | 21     2   | 4,5,6       | 4     3   | 7,8,9       | 7   

is possible using trigger or procedure. using mysql.

i think dont need trigger.you can update directly this.

   update user_level             set level_order = '21,22,23',             current_level=substring_index('21,22,23', ',', 1)             uid=1; 

sql fiddle demo