I currently have a search bar that is attached to a database of doctors. My problem is, I need to adjust the search bar so that when people search for people in the database, that no matter if they include all or part of their name, that the corresponding person appears.
For example:
If somebody was trying to search for “Dr. Homer Simpson” and they typed “Simpson” into the database searchbar, nothing currently appears because the search only works left to right and only shows results for “Dr. Homer”. How can I change it so it sets it to show results when only part is shown?