Sql select rows containing part of string

I want to write a comparation procedure (t-sql) for site seo.

I have a table with field ‘url’ (nvarchar()) that contain a part of site url’s. Ex: ‘mysyte.com/?id=2‘. Also this table for each url contains metadata, that i need to extract.

The main problem is that full url on site looks like ‘mysyte.com/?id=2&region=0&page=1‘, and i just need to ignore everething, except url in table:

I mean: ‘mysyte.com/?id=2’ => is a part of ‘mysyte.com/?id=2&region=0&page=1’

Answer

SELECT *
FROM myTable
WHERE URL = LEFT('mysyte.com/?id=2&region=0&page=1', LEN(URL))

Or use CHARINDEX http://msdn.microsoft.com/en-us/library/aa258228(v=SQL.80).aspx