Trying to use a variable in a Python SQL Select Query [duplicate]

Question

I am trying to search a database filtering by a category which the user chooses and selects. I have attempted to add a Variable into my Select Query but it keeps failing with a SQL syntax error but I cannot find any syntax issues

var1 = "World"
selectQ = """SELECT name, score FROM score WHERE category = %s"""
cursor.execute(selectQ, Var1)

The Error is mysql.connector.errors.ProgrammingError: 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%s' at line 1

Answer 1

You can try below,

var1 = "World"

cursor.execute("SELECT name, score FROM score WHERE category = %s", (var1))

Note, the parameters should be passed as tuple.