<div>
Yes. That works great. Thanks!
</div>


<div>
<div class="content wysiwyg-content">
In this MySQL query, I want to use a variable for the DocNumber, instead of the hardcoded '99':<br />
<br />
&nbsp; &nbsp; cursor.execute(&quot;SELECT DocText FROM compare WHERE DocNumber = '99' ORDER BY Posted ASC limit 1&quot;)<br />
<br />
I tried this, but it did not work:<br />
<br />
&nbsp; &nbsp;Doc = '99'<br />
. . .<br />
&nbsp; &nbsp;cursor.execute(&quot;SELECT DocText FROM compare WHERE DocNumber = 'Doc' ORDER BY Posted ASC limit 1&quot;)<br />
<br />
In Python, what is the proper syntax for using a variable inside a double-quoted sql statement in the cursor.execute function?
</div>
</div>


In this MySQL query, I want to use a variable for the DocNumber, instead of the hardcoded '99':

    cursor.execute("SELECT DocText FROM compare WHERE DocNumber = '99' ORDER BY Posted ASC limit 1")

I tried this, but it did not work:

   Doc = '99'
. . .
   cursor.execute("SELECT DocText FROM compare WHERE DocNumber = 'Doc' ORDER BY Posted ASC limit 1")

In Python, what is the proper syntax for using a variable inside a double-quoted sql statement in the cursor.execute function?

Syntax for a Variable in a MySQL Query in Python

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.