sql like query

[Kasmadi]

how to use like query pymysql ?

my code

sql="... LIKE %s"

not result

[INADA Naoki]

1) cursor.execute("SELECT ... LIKE %s", ("%HELLO",))
2) cursor.execute("SELECT ... LIKE '%%HELLO')

(2) is not documented intentionally. Other driver (e.g. MySQL Connector/Python)
doesn't support it.

> --
> You received this message because you are subscribed to the Google Groups "PyMySQL Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to pymysql-user...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--
INADA Naoki <songof...@gmail.com>

[Kasmadi]

thanks for your answer, but i have same error "unsupported operand type(s) for %: 'tuple' and 'tuple'", how to resolve it, thanks 

[INADA Naoki]

You should show code and real error + stacktrace when you ask such questions.