Hi YapDatabase group,
I'm working on an app that needs to search from a list of contacts, and I'm using the FTS extension and referencing the SearchResultsExample. I composed the query in the format of *%@*, and expect to get results that contains the search term, but it seems to ignore the first "*".
For example, there's a contact named "Jonathan"(I've added name into search column), and I search "jo"(query turns "*jo*"), it will be in the result, but if i search "lu"(query turns "*lu*"), it won't.
Is there anything wrong with the query?
Thanks in advance!
Jonathan