I have an app that will allow you to lookup the salaries of public officials. I have a few multiselect boxes to narrow the search by role and department. I am thinking about how to design the name search.
Are there clear best practices? Should I have a first and last name field? A single name field that lets the user enter in any name? What SQL logic should I connect to the input fields to the database? Should I do a "like" search to return all of the rows that might match the person?
It seems like the ideal thing would have something like a google search box that returned all possible hits on first and last name. There are only 3k rows in the DB so this seems feasible.