Is there a symbol for "any"?

Question

PostgreSQL

Good afternoon, let's say I have a 4-parameter select query, but I don't know how many parameters I will have when I run the query, can I specify a "special character" like name='any' to make this parameter did not affect the results of the sample?

Answer 1

You can write name LIKE '%'
Only here it is important not to forget to put a candelabra next to it and stretch out your arms.

Answer 2

classic:

...
where 
(@param1 is null or [email protected])
and
(@param2 is null or [email protected])
...
and
(@paramN is null or [email protected])

well, or wherever you like @paramM is null or fieldM like @paramM

Answer 3

For such purposes, they came up with the coalesce function ...