title: How to write a Query with a dynamic Where Clause
body: <p>I am writing a query that will retrieve data that match a set of criteria. Though the number and value of these criteria is unknown. It could be "name = username" and/or "date = today" and/or "title= hello" and so on. </p>
  
  <p>There are almost 10 different criteria and there could be only one selected as there could be 10 of them, so writing a query for each scenario is not likely. </p>
  
  <p>Does MySql have a syntax for such scenario ? If not what would be the best way to achieve that result ?  </p>