tokcum05/09/2022, 1:09 PM
. 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;
defensivedepth05/10/2022, 10:53 AM
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.
defensivedepth05/10/2022, 5:53 PM
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
defensivedepth05/11/2022, 10:04 AM
tokcum05/11/2022, 2:25 PM