We recently had to encrypt our data such as name, last name, dob etc using AES. We have a place in our software where a user can search by those attributes. While doing an exact match on the user input to the data works okay, we are not sure how to go with the queries that use LIKE . I would love to see just from ground up on the latest version of Laravel, a proper way of creating and interacting with an encrypted database. Encryption is becoming a must if it has not already so I think a lot of people will benefit from it.