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