Full text search query with "*" as prefix

6 views
Skip to first unread message

Jonathan Lu

unread,
Jun 21, 2016, 10:19:41 PM6/21/16
to YapDatabase
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
Reply all
Reply to author
Forward
0 new messages