# SQL, checking multiple dynamic parameters

**URL:** <https://forum.inductiveautomation.com/t/sql-checking-multiple-dynamic-parameters/65401>\
**Category:** Ignition\
**Created:** [October 19, 2022, 1:54pm UTC](https://forum.inductiveautomation.com/t/sql-checking-multiple-dynamic-parameters/65401 "2022-10-19T13:54:21Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:** [October 19, 2022, 6:37pm UTC](https://forum.inductiveautomation.com/t/sql-checking-multiple-dynamic-parameters/65401/6 "2022-10-19T18:37:40Z")

</div>

As a specific example of @pturmel's suggestion:

> [@prepQuery with WHERE IN() statement](https://forum.inductiveautomation.com/t/prepquery-with-where-in-statement/55359/3):
>
> 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/sql-checking-multiple-dynamic-parameters/65401)._