Re: How do I use parameterized queries with LIKE?
От
P. Christeas
Тема
Re: How do I use parameterized queries with LIKE?
Дата
Msg-id
201205290144.27622.xrg@linux.gr
Ответ на
How do I use parameterized queries with LIKE? (W. Matthew Wilson)
Список
Дерево обсуждения
How do I use parameterized queries with LIKE? "W. Matthew Wilson" <matt@tplus1.com>
Re: How do I use parameterized queries with LIKE? "P. Christeas" <xrg@linux.gr>
Re: How do I use parameterized queries with LIKE? Adrian Klaver <adrian.klaver@gmail.com>
Re: How do I use parameterized queries with LIKE? Daniele Varrazzo <daniele.varrazzo@gmail.com>
Re: How do I use parameterized queries with LIKE? "W. Matthew Wilson" <matt@tplus1.com>
Re: How do I use parameterized queries with LIKE? Federico Di Gregorio <fog@dndg.it>
10.6 Mac build - Intel only Brian Hamlin <maplabs@light42.com>
Re: 10.6 Mac build - Intel only Brian Hamlin <maplabs@light42.com>
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!
В списке psycopg по дате отправления
