Lets say I have a table with columns A , B , C , D and I want to do a match on column A and C
I see that you can either match a single column or all column in sqlite ie
- match column A
select * from table where A match 'cat'
- match all columns
select * from table where table match 'cat'
I don't think you can use multiple MATCH operators in a single FTS query. Use column_name:target_term to search multiple columns using one full text search.
SELECT * FROM table WHERE table MATCH 'A:cat OR C:cat'