title: SQL query to search for a record that has a certain text?
body: <p>How can I query for a record that has certain text input from the user?</p>
  
  <p>For example in my table adapter function:</p>
  
  <pre><code>SELECT Word, Description, Example  
  FROM WordLists  
  WHERE (Word LIKE @SearchKey OR Description LIKE @SearchKey OR Example LIKE @SearchKey)
  </code></pre>
  
  <p>Obviously only record that has the exact text from certain input will be acquired from the DB. What I need to do is to get all records that contains input texts from user.</p>