how to encrypt data in mysql database using update statement?

hello, im having trouble using update statement to encrypt the data in my schema.
im using md5 and need to encrypt sensitive data to be send to other DBA. is there a way to encrypt all data in one update statement? hope somebody can help me.thank you so much in advance