title: Search multiple database columns using one search box
body: <p>I was wondering what the best approach would be to search a database via multiple columns by using only 1 search box. Scenario below:</p>
  
  <p>I want to be able to search Customers by inputting their details into a search box. This could be either their name, post code or id. I can also perform 1 search by using more than 1 search  criteria. For example I could search by name and id (Bob Smith cus345).</p>
  
  <p>A first approach I took was to split the search term, seperating each space into a seperate word but this has its down fall as a customer name may contain 3-4 words. This can lead to a tonne of conditional statements but this is inefficient so I was wondering if there was a better way of doing this.</p>
  
  <p>I find this a difficult task to do because the user could search in any order (ie search by post code, then name and then id, or name and id and so forth)</p>