<p>使用python3在flask中尝试mysql查询</p>
<pre><code>SELECT title FROM Book WHERE title LIKE '%booktitlehere%';
</code></pre>
<p>从我的搜索表单的输入来看,这是一个尝试的烧瓶实现</p>
^{pr2}$
<p>当转到保存此表单的页面时,不会出现此错误</p>
<p>_mysql_异常。编程错误:不是所有参数都在字符串格式化期间转换</p>
<p>我尝试添加%%来转义%</p>
<pre><code>likeString = "'%%" + search_string + "%%'"
# print(like)
cur.execute("""SELECT title FROM Book WHERE title LIKE %s;""",likeString)
rv = cur.fetchall()
</code></pre>
<p>但还是出错了</p>
<pre><code>_mysql_exceptions.ProgrammingError: not all arguments converted during string formatting
</code></pre>
<p>也尝试了用双引号括住select</p>
<pre><code>cur.execute("SELECT title FROM Book WHERE title LIKE %s;",likeString)
</code></pre>
<p>示例:</p>
<pre class="lang-py prettyprint-override"><code>cari = "%" + request.form['cari'] +"%"
conn.execute("SELECT nama, harga FROM barang where nama LIKE %s OR harga LIKE %s", (cari, cari))
</code></pre>