title: Multi value wildcard search in ibatis
body: <p>I have a search field which can take values separated by blank spaces for multi value search. But now I want to make it multi value search using wildcards. For example if I add 'away%' and 'ds%' separated by blank space in the search field it should search for both wild card values in a given column. The query should be as :</p>
  
  <pre><code>SELECT * FROM [table]
  WHERE [column] LIKE ('away%') OR
  [column] LIKE ('ds%');
  </code></pre>
  
  <p>How can i achieve this repetitive column reference based on number of search values  ? P.S: search value can be of any number.</p>