How do I search for multiple values in a parameter?

Aarthi
Aarthi
  • Updated

You can search for multiple values in a parameter using or.

SELECT id, color, procession_rate
FROM alab.myosin_motor_protein
WHERE color = #{{Color}} or color = #{{Color2}}If you want users to be able to “search” for 1 or 2 or 20 different parameters, use an ANY query to search across each value.
SELECT id, color, procession_rate
FROM alab.myosin_motor_protein
WHERE color = ANY(string_to_array(#{{Color}}, ','))

Additional resources

https://www.postgresql.org/docs/9.1/functions-array.html
https://www.postgresqltutorial.com/postgresql-any/

Was this article helpful?

Have more questions? Submit a request