How to search for a user if first name and last name are stored separately in database

how to search for a user if first name and last name are stored separately in database

Have a firstLastName field and have it update using a backend trigger.