PDA

View Full Version : sqlite3 python and keyword like



jworr
October 29th, 2009, 06:13 AM
normally I a query with a 'like' keyword would look like this:

select * from some_table where name like '%foo%'

but since I'm using a parameterized queries with python's database interface my query now looks like this:

select * from some_table where name like ?

My issue is, I don't know how to specify the %. I've tried %?% and '%?%' but it doesn't work. Does anyone know how to do this?

jworr
October 29th, 2009, 06:32 AM
Never mind, I just added the %'s to the parameter