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/

Did this answer your question?