PII, or Personally Identifiable Information, involves information that may include the following, among other data:
- First Name
- Last Name
- Email Address
- Phone (any of them)
- Billing Address
- Shipping Address
Security researchers and legislation are recommending we encrypt the data. In my case, I'm using PHP7 and MariaDB. So, I can store encrypted PII using the latest recommended and battle-tested encryption APIs. However, now when I need an admin system, I need to be able to:
- Sort data by PII table columns
- Do case-insensitive partial keyword searches
Unfortunately, I'm not clear on how to do that smoothly with encrypted data stored in MariaDB (and which might also use PHP7).