How to implement a database record filter?

Question

SQL

How applicable is the implementation of a filter on the parameters of database records through a stored procedure? That is, the last name you enter, then the street you select, and so on.
1. Enter the person's last name - the first parameter.
2. Select the locality - the second parameter.
3. Choose the year of birth - the third parameter.
4. Then the procedure is executed and the records corresponding to the parameters are displayed.
PS How is the selection of goods in the online store implemented?
Thank you.

Answer 1

How applicable is the implementation of a filter on the parameters of database records through a stored procedure

all these conditions that you listed are just logical expressions in the WHERE of the most ordinary SELECT query
depends on the implementation of a particular store. or DBMS or NoSQL storage or full text search engine, etc. etc.