title: SQL command for when number of conditions for searching may vary
body: <p>So i have a React frontend that implements search operation on a mysql database. And for the search operation it can take 4 conditions (id, name, invoice, posting) as input. But its not necessary that a user needs to give values for all 4 conditions. A user can give values for anywhere between 1-4 condition.</p>
  <p>I cant quite figure out mysql command to perform this operation. Can someone help me writing this command using 'like' operator?</p>
  <p>Ps- Suppose user just gives id for searching. The all rows with that id should show. If user gives both id and name then rows matching that id and that name should show and so on..</p>