No results when using exact entry title
I have a problem where I am searching for an exact entry title and getting no results. The title has two words. Searching a single word finds the entry.
{exp:low_search:form search_mode="all" result_page="/{segment_1}/search" loose_ends="yes"}
<input type="text" class="search-input" name="keywords" value="{exp:low_search:keywords query="{embed:query}"}">
{/exp:low_search:form}
{exp:low_search:results query="{segment_3}" channel="magazines" limit="20" paginate="bottom"}
...
{/exp:low_search:results}
Replies
Low 30 Jun 2011 14:33
Hi Joshua,
We've discussed this over mail and Skype, so I'm just adding a note here for visibility.
MySQL's full-text functions (MATCH/AGAINST) won't index words that are below a certain length (4 by default). Smaller words will be ignored. Somehow, setting the loose_ends parameter to "yes" will force a lookup, which returns 0 rows. Turning loose_ends off again will give you search results again.
I'll be looking into a way to bypass the MATCH/AGAINST statement for words in the search string that fall below this threshold.
JoshuaBaker 22 Sep 2011 13:24
Hey Low
Just a quick message to see if there has been any update relating to this.
Please let me know.
Low 22 Sep 2011 13:29
Hi Joshua,
Version 1.0.5 has an extension setting for MySQL's stop words, and I'm currently in the testing phase for 1.0.6. One of the updates will be better handing of search terms that contain stop words or words smaller than the mentioned length.
If you want, I can send you a beta to test?