Re: OT Match Against
| From: | Richard Baskett | Date: | Tue, 09 Mar 2004 08:36:09 +0000 |
| Subject: | Re: OT Match Against | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-179876@lists.php.net to get a copy of this message | ||
> Do you have any idea why this query:
>
> SELECT hh_listings.listID, listingName, phone, email, held, venderID,
> hh_listings.disabled, hh_listings.deleted, hh_listings.levelID, levelName,
> islandName FROM hh_listings, hh_listlevels, hh_islands WHERE
> hh_listings.levelID=hh_listlevels.levelID AND
> hh_listings.islandID=hh_islands.islandID AND hh_listings.deleted!='1' AND
> MATCH (listingName) AGAINST ('spa*' IN BOOLEAN MODE) ORDER BY listID ASC
>
> Is not showing the listingName 'Spa Enterprises' or 'Everything Spa', but
> it
> is showing 'Spasms are us' or 'Loving Spat' all names are made up :)
>
> Basically if the word has spa in it then it matches, but if it the exact
> word.. it does not match.. what is going on?
>
> thanks!
>
> Rick
Ok someone told me the answer so I thought I would post it here for everyone
else.. basically it doesn¹t work with words less than 4 characters, unless
you set a certain variable on startup to use less than 4 characters when
using fulltext searching.
Cheers!
Rick