Python list of String to SQL IN parameter

Question

I have this query in python:

ssim_group = [S1200,S1300]

query = '''select WIPMessageCnt from waferdata where recipename in (%s) and equipment = ?
                             and runtype = ? order by  stopts desc limit 1''' % (','.join(ssim_grp))

print query

Current result

select WIPMessageCnt from waferdata where recipename in (S1200,S1460) and equipment = ? and runtype = ? order by stopts desc limit 1

Expected result should be like this

select WIPMessageCnt from waferdata where recipename in ('S1200','S1460') and equipment = ? and runtype = ? order by stopts desc limit 1

The list should have single qoutation on each element when I try to put them inside the IN parameter on SQL. How can I achieve this?

Possible duplicate of How to Pass a List of String in MySQL Stored Procedure? — Lukasz Szozda
– Lukasz Szozda, Commented Jan 20, 2016 at 10:57

yanghaogn · Accepted Answer · 2016-01-20 11:44:25Z

5

ssim_group = ['S1200', 'S1300']
query = '''select WIPMessageCnt from waferdata where recipename in ('%s') and equipment = ? and runtype = ? order by  stopts desc limit 1''' % ("','".join(ssim_group))

answered Jan 20, 2016 at 11:44

yanghaogn

8637 silver badges15 bronze badges

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

1 Comment

Nikhil Talreja Over a year ago

this does not work if string has a quote like ['S1200', "S1300's"]

Collectives™ on Stack Overflow

Python list of String to SQL IN parameter

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related