How to apply advance search query with multiple values and conditions | MySQL

I have a view where user select fields to make an advance search, the fields are : name- age - location - isPaid - date_subscription, date_expiration the user might choose one column or make combinations of multiple columns, i am confused if i should use if statement to detect which columns are selected, and then run the query depends on the selected column, but this way i will need to set all the valid conditions, which mean set the all the valid combination. is there a other way to execute such queries?

Many Thanks