Should I encrypt email addresses in the database?

Question

Email

Actually, there is a certain project, it will store the email addresses of users.
We don't want email addresses to be exposed to the public.
In the yard of the 21st century, there are all sorts of spam filters.
So should you encrypt the email addresses in the database or leave them all as they are?
How do you store email addresses?

Answer 1

Mail is not a password. And mail sometimes needs to be decrypted in order to send a notification to the user or recover the password. IMHO - it's pointless to encrypt.

Answer 2

In a good way, you need to encrypt all user data. In the case of an injection, you will not reveal the entire database, as well as in the case of automatic hacking. It won't help much against a targeted attack.
Also, encryption is not very effective when the storage and processing of this data will be on the same server.