MySQL Update on Same Table

If any chance to do an UPDATE on the same table, here is the SQL for that

UPDATE my_list AS a 
INNER JOIN my_list AS b 
ON a.id = b.id 
SET a.list_name_val = md5( b.list_name )

the above SQL will update list_name_val column with md5 of list_name.