title: SQLite ERROR no such column Python
body: <p>I have a problem, i am trying to do a validation between a username to that username email by compairing the rowid in python and SQLite, here is the code: </p>
  
  <pre><code>username = self.txtUsername.GetValue()
  email =  self.txtEmail.GetValue()
  UsernameE  = self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Username="
    + username)
  EmailU = self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Email=" + email)
  </code></pre>
  
  <p>The error is: </p>
  
  <pre><code>&gt; UsernameE  = self.conn.execute("SELECT rowid,* FROM tblPlayers WHERE p_Username="
        + username)
  sqlite3.OperationalError: no such column: "what i inserted in the username"
  </code></pre>