Programming Tip -How can I write an SQL IN query with a Python tuple?

<p dir="auto"><img src="https://images.hive.blog/768x0/https://steemitimages.com/DQmW2uViAfWVSCc4NRmA38Gv1zVQJwsz2ELN2xYq7UzMEga/EBOOK_PYTHON_no-name.png" alt="EBOOK_PYTHON_no-name.png" srcset="https://images.hive.blog/768x0/https://steemitimages.com/DQmW2uViAfWVSCc4NRmA38Gv1zVQJwsz2ELN2xYq7UzMEga/EBOOK_PYTHON_no-name.png 1x, https://images.hive.blog/1536x0/https://steemitimages.com/DQmW2uViAfWVSCc4NRmA38Gv1zVQJwsz2ELN2xYq7UzMEga/EBOOK_PYTHON_no-name.png 2x" /> <hr /> <blockquote> <p dir="auto">Today i am going to show Programming Tip - How can I write an SQL IN query with a Python tuple with simple code. I hope you will understand this.<br /> If you have any query you can ask.<br /> i hope you will like it.<br /> <br /><br /> <pre><code>my_tuple = ("Hello", "world", "John") placeholder= '?' placeholders= ', '.join(placeholder for _ in my_tuple) query= 'SELECT name FROM students WHERE id IN (%s)' % placeholders print(query) # now execute using the cursor cursor.execute(query, my_tuple) This will give the output 'SELECT name FROM students WHERE id IN (?, ?, ?)' <p dir="auto"><center> <p dir="auto"><br /><br />========================================================= <span>Follow me at : <a href="https://steemit.com/@ahmadhassan" target="_blank" rel="nofollow noreferrer noopener" title="This link will take you away from hive.blog" class="external_link">https://steemit.com/@ahmadhassan <p dir="auto"><span><img src="https://images.hive.blog/0x0/https://steemitimages.com/DQmYfKYGX2M8Qc8nNUi6TqUzHKoeLmafZ6PVBMjt7wjXe5R/99.gif" /> <br /> Thanks for reading and always welcome your suggestions :) =========================================================