Concatenate SQL string with args

Question

I am trying to use a default query and then append some conditions. I would like to know how can i concatenate a string while unpacking args.

filters = []
if industry:
    filters.append('industry_id')
    filters.append('role_id')
    ...

As far as I can see this doesn't work (invalid syntax).

print "SELECT city, " + *filters + " FROM histogram"

sal · Accepted Answer · 2019-04-26 02:23:41Z

1

Use join to do what you need:

print "SELECT city, " + ', '.join(filters) + " FROM histogram"

which prints:

SELECT city, industry_id, role_id FROM histogram

answered Apr 26, 2019 at 2:23

sal

3,6031 gold badge13 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1