Using url query params in SQL queries

[Vince Allen]

Is it possible to use url query parameters in SQL query? For example, I'd like to pass an id to a page and execute the following sql.

SELECT * FROM Projects WHERE id = '$id'

[Bob Swift OSS (Bob Swift Atlassian Apps)]

This is answered here: https://bobswift.atlassian.net/wiki/questions/104989347

[Ben Stuart]

Hey Vince,

Are you trying to  find what project is associated with an ID? 

This query worked for me in SQL workbench: SELECT * FROM <dbName>.project WHERE id = 21

Regards,
Ben Stuart