I had a... suboptimal experience with SQLite's FTS, so here it is for others: match queries don't work with `OR` conditions. You have to do this work around:
WHERE
fa.rowid IN (SELECT rowid FROM address_fts WHERE address_fts MATCH 'google')
OR
ta.rowid IN (SELECT rowid FROM address_fts WHERE address_fts MATCH 'google')
I'm building a search feature for my app, that parses a user's search query (a la Github search) and returns relevant results. Generating the above workaround SQL on the fly is just... ulgh.
I'm building a search feature for my app, that parses a user's search query (a la Github search) and returns relevant results. Generating the above workaround SQL on the fly is just... ulgh.