. I did some research on how to query with case insensitive and after some tests with lower(), I found this solution:
Without "COLLATE NOCASE" this statement will not match different spellings like "refusepasswordchange". Any other thoughts on this?
SELECT * FROM registry WHERE path = "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Netlogon\Parameters\RefusePassworChange" COLLATE NOCASE;
filter, it has to match.
does double duty. First, it is passed to the underlying table’s generate routine to generate data. Second, it’s used by sqlite to filter.
is a good one •
is always case insensitive •
probably also good I don’t remember if there are performance implications. But probably not, since you’re hitting the registry so it’s not going to be that fast