Resident Load not like '*string*'

[#1]

Hi *,

how can I manage to filter keywords in strings? I'm trying to load URLs that don't contain e.g. "?id=422"

LOAD looks like this:

LOAD url Resident List WHERE url not like '*?id=422*'.

Unfortunately "<>" doesn't work with with wildcards.

Thanks in advance.

Aloah

[disqr_rm]

Hi Aloha, Try:

LOAD
url as newurl
Resident List
WHERE wildmatch(url, '*?id=422*') = 0;

Thanks

[#3]

Works. Thanks a lot.