title: Python: Extract TEXT from sqlite3 as a string
body: <p>First week programming in any language and need some help: Im trying to extract a TEXT value as a string from sqlite3 in Python.  Im getting a value as a list not a str:</p>
  
  <pre><code>system_id = raw_input ("What is your System ID: ")
  </code></pre>
  
  <p>For example the user enters 'Elmer'</p>
  
  <pre><code>conn = sqlite3.connect("API.db")
  c = conn.cursor()
  c.execute('''CREATE TABLE IF NOT EXISTS SYSTEMID (systemid TEXT)''')
  conn.commit()
  conn.close()
  
  conn = sqlite3.connect("API.db")
  c = conn.cursor()
  system_id = c.execute('select systemid from SYSTEMID').fetchall()
  conn.close()
  </code></pre>
  
  <p>So how to make the variable system_id as a string?  If I print from this I get something like [(u, Elmer)], I want system_id = Elmer</p>