title: How to properly use LIKE and '%%' in python to search a database list for a partial response stored in a placeholder variable?
body: <pre><code>search = request.form.get(&quot;search&quot;)
  
  book = db.execute(&quot;SELECT * FROM books WHERE title = :search OR author = :search OR isbn = :search OR title LIKE :search&quot;,{&quot;search&quot;: search}).fetchall()
  </code></pre>
  <p>This is a portion of my function. I want the user to be able to search for a book and store their result in &quot;search&quot;, and I want to be able to pull any results from the database list that at least has the &quot;search&quot; even if the title isn't complete. Example, if the user is looking for a book titled &quot;the fisherman&quot; but the user only types in &quot;the fisher&quot; I want the query to be able to pull &quot;the fisherman&quot;.</p>