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