I've just discovered on version 3.04 that it doesn't matter whether or not I have search substring set that GLinksSQL always searches for substrings.
http://mastersonsantafe.com/cgi-bin/jewelman/search.cgi?query=ring&bool=and&mh=25&substring=0
http://mastersonsantafe.com/cgi-bin/jewelman/search.cgi?query=ring&bool=and&mh=25&substring=1
Here's part of the stack query dump to prove what I'm talking about. It's the same for substring=0 and substring=1
my database is nonindexed.
SELECT ID FROM Links WHERE (((( Title LIKE '%ring%' OR Description LIKE '%ring%'))) AND (isValidated = 'Yes'))
thank you for posting a fix for this.
peace.
http://mastersonsantafe.com/cgi-bin/jewelman/search.cgi?query=ring&bool=and&mh=25&substring=0
http://mastersonsantafe.com/cgi-bin/jewelman/search.cgi?query=ring&bool=and&mh=25&substring=1
Here's part of the stack query dump to prove what I'm talking about. It's the same for substring=0 and substring=1
my database is nonindexed.
SELECT ID FROM Links WHERE (((( Title LIKE '%ring%' OR Description LIKE '%ring%'))) AND (isValidated = 'Yes'))
thank you for posting a fix for this.
peace.