Analytical ADQL query

[Rathinakararaj_]

I am looking for an analytical query to fetch list of URLs from browser records that does not match a pagename  with http and without http and with partial URL segments...

example : select * from browser records where pagename is not in ("abc.com", "https://abc.com",%abc.com%) 

[Morelz · Accepted solution]

Hi @Rathinakararaj.Sundaraj 

Can you not use something like below?

SELECT * FROM browser_records WHERE pagename not like "*abc.com*"

Ciao