mysql - update a row without sql triggers -

i have table called tasks , in tasks users complete. possible make task complete if other tasks user complete. know can sql triggers wanted know if there's more elegant way this.

this includes making new task , therefore making final task incomplete