mysql - Dynamic search filter with multiple factors in web app -

i'm building real estate website , i'm little bit confused on how filter apartment search results. user can filter search clicking on check boxes , textbox contains keywords search for.

my problem have many filtering options (by city and/or location in city and/or apartment size and/or number of bed rooms and/or ... ). problem how write mysql stored procedure can dynamic accept different inputs , give filtered results pagination. example, can choose number of bedrooms 2 or 3 in filter , in city , might not care other conditions. , user might put keyword along conditions search for. i'm using spring mvc , mysql guess need more concept languages , relational db i'm using.

at first, though of passing key value pairs complicate things lot in procedure guess , depend on enum tables. so, can please suggest proper way implement kind of search based on best practices , expertise.

many thx

faceted search analytic problem, meaning need analytic schema properly.

this means dimensional design. means olap-style querying.

so, should read up on first.

basically, want 1 big table (where each row house sale), applicable columns. doesn't have real table, view or materialized view.

i'd pass on using sprocs this. don't see how help.