OT Match Against
| From: | Richard Baskett | Date: | Tue, 09 Mar 2004 07:24:49 +0000 |
| Subject: | OT Match Against | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-179873@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