LiveCode Forums.

I try to get a result of a query similar to
select * from table1 where table1 match 'abc -def'

This should return all rows with the value abc and not def in one of its columns. It works in sqlite browser. But not in LiveCode. It ignores the - part. Also tried NOT.

Same with the or operator. It just removes it or something?... Bad behavior.

Also when using a :1 in the match query it only returns the 1 result.

Any ideas?

Also when using a :1 in the match query it only returns the 1 result.

well, that happens to be the case if i enter it like ':1' int the query. If I just use :1 without quotes that works.
Still... livecode seems to rip of the other operators.? Maybe buildin safety, but in this case one needs it in order for sqlite powerful match functionality to work...
https://www.sqlite.org/fts3.html