title: How do I find duplicates within a database and how do I execute a response?
body: <p>My program shows a search bar for a manager to search for players in a team, i have it so that my program returns "found" when the database finds the search item in the database, however, in the event that more than one players have the same first name, last name or username I need to notify the manager to be more specific in their search, this is because if successful the search will show a page with all that specific user's stats. </p>
  
  <p>i have tried using the COUNT function in sqlite3 however, i haven't been able to find a good explanation online which tells you how to establish duplicates and then act upon the information.</p>
  
  <p><a href="https://i.stack.imgur.com/irxdx.png" rel="nofollow noreferrer">Code so far</a></p>