How to give parameters in SQL query having LIKE keyword

Question

I have a Workers SQLite table and I am trying to display all workers whose name starts with a particular character input by the user.

letter = input("\nEnter starting letter of worker: ")
(cursor.execute("SELECT * FROM Workers WHERE Worker_Name LIKE '(?)%'", (letter,))).fetchall()

But I always keep getting this error:

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

But when I give like this, it works:

(cursor.execute("SELECT * FROM Workers WHERE Worker_Name LIKE 'J%'")).fetchall()

GMB · Accepted Answer · 2020-11-24 10:01:26Z

2

Use string concatenation in the query:

cursor.execute("SELECT * FROM Workers WHERE Worker_Name LIKE ? || '%'", (letter,))

... Or use string concatenation in your application code:

cursor.execute("SELECT * FROM Workers WHERE Worker_Name LIKE ?", (letter + "%",))

answered Nov 24, 2020 at 10:01

GMB

224k25 gold badges103 silver badges151 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Animeartist Over a year ago

Thank you so much! The first method was the one which worked for me. I had tried the second method earlier but it was giving me the same error.

Mark Rotteveel Over a year ago

@Animeartist If the second gave you an error, you probably tried LIKE '?' instead of LIKE ?. A question mark inside a string literal is not a parameter, it is just a string with a question mark.

Collectives™ on Stack Overflow

How to give parameters in SQL query having LIKE keyword

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related