title: sqlite3.OperationalError: no such column: year
body: <p>Using SQLite3 and got this error:</p>
  
  <blockquote>
    <p>sqlite3.OperationalError: no such column: year</p>
  </blockquote>
  
  <p>SQLite3 newbie over here. 
  Really confused right now as to what part of the code went wrong...</p>
  
  <pre><code>import sqlite3
  
  def connect():
      conn=sqlite3.connect("books.db")
      cur=conn.cursor()
      cur.execute("CREATE TABLE IF NOT EXISTS book (id INTEGER PRIMARY KEY, title text, author text, year integer, isbn integer)")
      conn.commit()
      conn.close()
  
  
  
  def search(title="",author="",year="",isbn=""):
      conn=sqlite3.connect("books.db")
      cur=conn.cursor()
      cur.execute("SELECT * FROM book WHERE title=? OR author=? OR year=? OR isbn=?",(title,author,year,isbn))
      rows=cur.fetchall()
      conn.close()
      return rows
  
  connect()
  print(search(year=1918))
  </code></pre>
  
  <p>Any help would be appreciated, thanks!!!</p>