I would like to find words beginning with punctuation such as
?uestlove
*NSYNC
I when searching on LIKEP *NSYNC, I get this error:
Query `*NSYNC' would require linear dictionary search: Index expression(s) match non-prefix substring of term `*nsync'
I also tried ecaping the * with \*, same error.
Do I need to add a specific index expression to handle this?
If your Webinator version has it, set Allow Leading Wildcards to Y under All Walk Settings. This will allow leading-wildcard searches such as `*nsync'. These searches are normally disabled, because they require a linear dictionary search: this can be slower than a normal (binary-dictionary) index search, though it is not as slow as a full linear search.
Make sure you set any APICP settings via <apicp> where possible, instead of <sql "set ...">, as the latter may not propagate properly all the time. E.g. qminprelen is settable via <apicp>, whereas wildsingle is not, so they should be set thusly: