cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Analytical ADQL query

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%) 

 

 

1 REPLY 1

Mario.Morelli
Architect

Hi @Rathinakararaj.Sundaraj 

 

Can you not use something like below?

 

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

 

Ciao



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

Learn more about me in the Community Member Spotlight Q & A