Encrypting/Decrypting data in MySQL

How can we encrypt and decrypt a data presented in a table using MySQL?

https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html