Suresh:

contains give you result which contains your search parameters....use LIKE Instead

OR you can use LEFT as below

WHERE URL = LEFT('')