Anonymous

alias pre.test {
  if ($chr(47) !isin $1-) {
    echo -a SELECT * FROM predb WHERE release LIKE $+($chr(39),$chr(37),$replace($1-,$chr(32),$chr(37)),$chr(37),$chr(39)) ORDER BY time DESC
  }
  else { 
    set -u0 %pre.test.search.string.base SELECT * FROM predb WHERE release LIKE $+($chr(39),$chr(37),$replace($deltok($1-,-1,32),$chr(32),$chr(37)),$chr(37),$chr(39))
    set -u0 %pre.test.filter.string $replace($gettok($1-,-1,32),$chr(47),$chr(32))
    set -u0 %pre.test.filter.string.total $numtok(%pre.test.filter.string,32)
    set -u0 %pre.test.filter.string.counter 1
    while (%pre.test.filter.string.counter <= %pre.test.filter.string.total) {
      set -u0 %pre.test.filter.output %pre.test.filter.output AND release NOT LIKE $+($chr(39),$chr(37),$gettok(%pre.test.filter.string,%pre.test.filter.string.counter,32),$chr(37),$chr(39))
      inc %pre.test.filter.string.counter 1
    }
    ;SELECT * FROM predb WHERE release LIKE '%some%string%' AND release NOT LIKE '%a%' AND release NOT LIKE '%b%' ORDER BY time DESC
    echo -a %pre.test.search.string.base
    echo -a %pre.test.filter.output
    echo -a %pre.test.search.string.base %pre.test.filter.output ORDER BY time DESC
  }
}