Fulltext matching
| From: | Peter Beckman | Date: | Mon, 02 Dec 2002 19:51:58 +0000 |
| Subject: | Fulltext matching | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23777@lists.php.net to get a copy of this message | ||
Is there any way in PHP and MySQL to find out the most used words in a full
text index? Is there access to the index? In the index I want to show the
words that occur the most in descending order limit 50.
In addition, is there any way to search for, without boolean (using
3.23.??), words in a row? I've tried searching for "print pal" (which I
know exists) but only get print and pal returned as two separate words, and
since pal is 3 letters or less, it isn't indexed.
This doesn't work:
select id, match(body) against ('"print pal"') from body where match(body)
against ('"print pal"');
Peter
---------------------------------------------------------------------------
Peter Beckman Internet Guy
beckman@purplecow.com http://www.purplecow.com/
---------------------------------------------------------------------------