how to use like percentage(like %) inside mysql query in python

Asked May 17 '19 at 07:22

Active May 17 '19 at 07:37

Viewed 56 times

I am working in python by retrieving data from mysql but its showing error as

ValueError: unsupported format character 'a' (0x61) at index 101

the query written in python as below

adminperday = """SELECT count(*) as cnt FROM users where name like "%admin%" and date(reg_date) between %s and %s """ % (startdate,enddate)

its showing error near like "%admin%".

Please help me.

edited May 17 '19 at 07:37

asked May 17 '19 at 07:22

learningstudent

Use singe quote like this '%admin%'. – Ananth Cool May 17 '19 at 07:25
@Ananth That's irrelevant. – deceze May 17 '19 at 07:25
1

FWIW, shouldn't you be using your mysql adapter's prepared statement interpolation feature instead of doing `%` string interpolation? – deceze May 17 '19 at 07:26
@AnanthCool: single quotes didnt help. tried with that. – learningstudent May 17 '19 at 07:27

0 Answers0