> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
