title: sqlite3 “OperationalError: near ”)“: syntax error” python
body: <p>This function is supposed to check for the ingredient the user entered following the prompt.  When I try this query statement in sqlite (without the user input of course) it works.  In python it says there is an error!    </p>
  
  <pre><code>def checkIngredient():
  
     usrIngredient = input("\nEnter an ingredient that you would like to make a drink with: \n\n")
  
      query = c.execute("SELECT DRDESC FROM Drinks WHERE DRDRID IN "
      "(SELECT DTDRID FROM Detail WHERE INGID ="
      "(SELECT INGID FROM Ingredients WHERE INDESC LIKE))", (usrIngredient,))
  
  
      resultset = c.fetchall()
  
      for result in resultset:
          if resultset is not None:
              print(result)
          else:
              print("Sorry, there are no drinks with that ingredient")
  </code></pre>