title: How to search (or select) all rows in selected column in SQLite3 with Python?
body: <p>I am trying to find out how to search (or select) all rows in a column, regardless of whether I know the length of the column or not.</p>
  
  <p>I am testing out how things work with SQLite and while trying to do a simple inclusion check (seeing if a user entered bit of information is already contained within a specific column in the database) I noticed that no matter what I typed into the <code>row[]</code> command I always got back only the entry from the first row (as if I'd used <code>row[0]</code>)</p>
  
  <p>here is my bit of code:</p>
  
  <pre><code>import sqlite3
  conn = sqlike3.connect("testDb.DB")
  c = conn.cursor()
  
  def createUsr():
      global usrName_
      usrName_ = input('Enter your desired username: ')
      usrName_Search = c.execute('SELECT usrName from usrInfo')
      for row in usrName_Search:
          if usrName_ in row[]:
              print('Username taken')
              createUsr()
          else:
              print('username created')
              c.execute('INSERT INTO usrInfo VALUE ?', (usrName_,))
  
  createUsr()
  </code></pre>
  
  <p>This is a shortened version of the actual code (the other one had more values, but this was the bit that was erroring so I decided to focus on this)</p>
  
  <p>I don't know what I need to enter into <code>row[]</code> to select every entry, or if there is another way I should be going about doing this. Any help would be greatly appreciated</p>