Formatting % in sql in python

Asked Jul 15 '19 at 20:49

Active Jul 15 '19 at 20:49

Viewed 26 times

I have run into this issue before but for the life of me I cannot remember how I dealt with it. I have the following query I need to use:

cursor.execute('''SELECT CASE WHEN GROUP_CONCAT(territory) NOT LIKE '%,%' THEN 'XXX' END
                  FROM myTable
                  WHERE i.id = %s AND territory_id=%s''', (self.pk, territory))

How do I escape the '%,%' in the sql query? Basically, I'm trying to find if the group_concat contains multiple elements.

asked Jul 15 '19 at 20:49

David542

101,766
154
423
727

Please provide sample data, desired results, and an explanation of the logic you want to implement. – Gordon Linoff Jul 15 '19 at 21:03
Use `\` to escape `%`. Check this answer: https://stackoverflow.com/a/881208/2469308 – Madhur Bhaiya Jul 16 '19 at 10:04

Formatting % in sql in python

0 Answers0