擅长:python、mysql、java
<p>您需要用<code>\</code>字符转义谓词,如下所示:</p>
<pre><code>SELECT * FROM metadb WHERE name = 'Valentine\%27s Day' and year = '2010' and type = 'movie'
</code></pre>
<p>你的猜测是对的。<code>%</code>是<a href="http://dev.mysql.com/doc/refman/5.7/en/string-literals.html" rel="nofollow">special character in MySQL</a>。另外,在将记录插入表之前,我可能会考虑使用url解码/编码库。你知道吗</p>