Using parametrized SQL staement to check substring
<p>I'm using <code>python MySQLdb</code></p>

<p>Here's my line of code:</p>

<pre><code>    cursor.execute("SELECT F_Title FROM Films WHERE F_Title LIKE  \"%%s%\"", [search])
</code></pre>

<p>I get the error:</p>

<pre><code>ValueError: unsupported format character '"' (0x22) at index 53
</code></pre>

<p>I'm trying to check id the <code>search</code> variable is a substring of any of the <code>F_Title</code> values</p>

<p>I've also tried:</p>

<pre><code>... WHERE F_Title LIKE '%%s%'"

... WHERE CONTAINS(F_Title, '&amp;s'")
</code></pre>

<p>Any ideas? </p>