How to filter queries (IOS)


#1

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

#2

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.)