SQL Query that contains a URL

Question

I have the query below. I want to receive records that doesn't include

mywebsite.com/url

but that includes

mywebsite.comurl

:

SELECT COUNT(*) 

FROM [mydb].[dbo].[mytable] 

WHERE No is not null 

AND Thumbnail is not null 

AND Thumbnail not like '<a target=\"_blank\" href=\"http://www.mywebsite.com/%'

When I run the query, it gives me an unexpected number. What is wrong with the query, how can I make it work correctly?

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

 SELECT COUNT(*) FROM [mydb].[dbo].[mytable] WHERE No is not null
 AND Thumbnail is not null
 AND Thumbnail like '%mywebsite.com%'
 AND Thumbnail not like '%mywebsite.com/url%'

SQL Query that contains a URL

Sign up