sqlite3.OperationalError: near "%": syntax error searching wildcard

user_10482778 0
Viewed 222

I am trying to do a query to search all name with giving letter with wild card and placeholder

cursor.execute("SELECT * FROM article WHERE name LIKE %(?)%", (letter,)).fetchall()

but I am keep getting this error

sqlite3.OperationalError: near "%": syntax error
sql-like sqlite python
1 Answers

You must concatenate the wildcards to the placeholder:

cursor.execute("SELECT * FROM article WHERE name LIKE '%' || ? || '%'", (letter,)).fetchall()
user_104988280
Related