How can I set password in SHA format?

I want set a nationalnumber as password in SHA format with subquery

UPDATE ct_user  SET password  = crypt(select nationalnumber from ct_user where username='6960004', gen_salt('md5'));