/Python/Sqlite query using string as parameter in python

Sqlite query using string as parameter in python

import sqlite3

conector = sqlite3.connect("database.db")
cursor = conector.cursor()
string = "Some interesting stuff"
cursor.execute("SELECT * FROM table WHERE item = ?", [string])

Similar codes

5 votes370 views2 answers
Python windows notification
Python
1 vote314 views1 answer
How to use an indefinite number of args in python
Python
2 votes291 views1 answer
Python backslash in string
Python
1 vote298 views1 answer
How to execute python program in ubuntu
Python
0 vote296 views1 answer
Split by backslash python
Python
1 vote314 views1 answer
How to calculate average in list python by using whil loop
Python
0 vote299 views1 answer
Scatter density plot seaborn
Python
14 votes265 views2 answers
Tkinter clear canvas
Python
4 votes274 views2 answers
How to scatter plot in matplotlib of two sets
Python
-1 vote303 views1 answer
How to code a trading bot in python
Python