Data Encryption Codeigniter

I wanted to ask is there a best practice for encrypting data in a Mysql table or is it a good idea or a bad idea ?

I am using Codeigniter, I could use the Encryption Class but the problem is we need to be able to search data. If the data is encrypted then our searches for "like" would be affected. So not sure what to do.