python sqlite3: How to use LIKE and ? to do partial matching?

Question

With python sqlite3, I'd like to something like

cursor.execute('SELECT * FROM songs WHERE filename LIKE "?%"', (key_string,))

so that I can use the key as a variable instead of having to hard code the pattern. But this does not work and gives me:

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

Please help.

kakyo · Accepted Answer · 2013-11-19 05:16:45Z

2

Figured out the answer my self:

cursor.execute('SELECT * FROM songs WHERE filename LIKE ?', ('{}%'.format(key_string),))

answered Nov 19, 2013 at 5:16

kakyo

11.8k14 gold badges95 silver badges173 bronze badges

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

2 Comments

what is the key_string? is it the matching string?

@east.charm a string to use as a keyword