Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Current Version (V3) Forum > Questions
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Important - The support forums are now in "read-only" mode as we transition to an alternative help desk solution. Feel free to contact us here with any of your questions or search the forums for an existing solution.
 
 
Thread Tools Search this Thread Display Modes
  #1  
Old December 1st, 2012, 12:51 PM
Michaelgs Michaelgs is offline
 
Join Date: Jun 2012
Posts: 65
Default bad search results

Store ID: 38485
Website URL: http://partythemesforbirthday.com
URL to page in question: all

when using a phrase or title like "my little pony" I get unacceptable results that include products who contain any word i.e. my, little, pony, and my little pony.

how exactly can i fix this so that I do not get pages of results but only the full phrase result.
I as the webmaster can of course surround the phrase my little pony with quotes and than I get the desired results, however the average visitor will not do that and sees the page with irrelevant results and leaves my site frustrated.

<!-- Search Fields -->
<ul>
?php if (@$_GET['word']){ ?><li><b>Word: </b>[store.get param="word"]</li><?php } ?>
<?php if (@$_GET['merchant']){ ?><li><b>Merchant: </b>[store.get param="merchant"]</li><?php } ?>
<?php if (@$_GET['tags']){ ?><li><b>Tags: </b>[store.get param="tags"]</li><?php } ?>
<?php if (@$_GET['price']){ ?><li><b>Price: </b>[store.get param="price"]</li><?php } ?>
</ul>
<!-- /Search Fields -->
looking at the first line of the search fields can I replace 'word' with 'phrase' ?
__________________
Michael G. Schurmann
Birthday Party Themes
  #2  
Old December 1st, 2012, 02:16 PM
Eric's Avatar
Eric Eric is offline
Datafeedr Team
 
Join Date: Feb 2008
Posts: 16,902
Default

Hi Michael,

The search returns the most relevant search results based on MySQL's built-in Full Text search: http://dev.mysql.com/doc/refman/5.1/...xt-search.html

It's going to try to return the most accurate results based on whatever words are chosen.

However, the word "my" is probably not being indexed by MySQL because by default MySQL's minimum word length for an indexed word is 4 characters. So MySQL is probably ignoring the word "my" when you use it in the search. Here's more info about that: http://www.datafeedr.com/forums/showthread.php?t=1572

But to answer your question, it's not really possible to change this.

Eric
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Search returning no results digitalcow Problems 2 November 13th, 2011 09:14 AM


All times are GMT -5. The time now is 09:28 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.