# prepQuery with WHERE IN() statement

**URL:** <https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359>\
**Category:** Ignition\
**Tags:** ignition81, scripting\
**Created:** [January 25, 2022, 3:37pm UTC](https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359 "2022-01-25T15:37:03Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [January 25, 2022, 3:48pm UTC](https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359/3 "2022-01-25T15:48:25Z")

</div>

```auto
usages = [301,311]
queryString = """SELECT *
				FROM distribution_config
				WHERE usage_id IN ({})""".format(','.join(['?']*len(usages)))
pyds = system.db.runPrepQuery(queryString,usages,"base_administrateur")	

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359)._