title: sqlite-net query with parameter that contains multi instructions
body: <p>I have a table with lots of information and now I want that a user can search that table.</p>
  
  <pre><code>List&lt;Table&gt; tableSearch = new List&lt;Table&gt;();
  string[] words = searchString.Split(' ');
  string sqlSearch = "";
  foreach (string word in words)
  {
      sqlSearch += " and Searchstring LIKE "+ "'%" + word + "%'";
  }
  tableSearch = db.Query&lt;Table&gt; ("select * from Table WHERE 1 = 1" + sqlSearch);
  </code></pre>
  
  <p>This is working and the solution I want to get to.
  The problem is, that when the searchString is something like <code>Dü</code>, <code>D'</code> I get an exception.</p>
  
  <p>I found here <a href="https://stackoverflow.com/questions/16705558/sqlite-net-like-statement-crashes">sqlite-net like statement crashes</a> a good solution for the problem.</p>
  
  <p>My problem is, that the only solution I found for now is something like:</p>
  
  <pre><code>if (words.Length &lt; 2) 
      tableSearch = db.Query&lt;Table&gt; ("select * from Table WHERE Searchstring LIKE ?", "%" + words[0] + "%");
  else if (words.Length &lt; 3) 
      tableSearch = db.Query&lt;Table&gt; ("select * from Table WHERE Searchstring LIKE ? and Searchstring LIKE ?", "%" + words[0] + "%", "%" + words[1] + "%");
  </code></pre>
  
  <p>and so on......</p>
  
  <p>but this is not the solution I want.</p>
  
  <p>Someone got an Idea?</p>