Re: How do I use parameterized queries with LIKE?

On Tuesday 29 May 2012, W. Matthew Wilson wrote:
> This works just fine:
>
> cursor.execute("""select email_address from customer where
> email_address like '%matt%'""")

You'd probably need to escape the percent signs like:
cursor.execute("""select email_address from customer where email_address like
'%%matt%%'""")

--
Say NO to spam and viruses. Stop using Microsoft Windows!