title: Sql select rows containing part of string
body: <p>I want to write a comparation procedure (t-sql) for site seo.</p>
  
  <p>I have a table with field 'url' (nvarchar()) that contain a part of site url's.
  Ex: '<em>mysyte.com/?id=2</em>'. Also this table for each url contains metadata, that i need to extract.</p>
  
  <p>The main problem is that full url on site looks like '<em>mysyte.com/?id=2&amp;region=0&amp;page=1</em>', and i just need to ignore everething, except url in table:</p>
  
  <p>I mean: 'mysyte.com/?id=2' => is a part of 'mysyte.com/?id=2&amp;region=0&amp;page=1'</p>