How to filter queries (IOS)

Hi,

i’d like to filter queries to match only rows with keys that have a contain a substring of a search request. Is this possible with queries? I don’t like to use views for this purpose because they are to “fix”.

Greetings,

Ralf

You can do prefix matching but not general substring matching. That’s just due to the way an index works. The only way to do full substring matching is to brute-force iterate through every row in the index. (Which is what, for example, SQLite would do if you used a LIKE operator.)