Re: Search by "AND"....

I currently don't support "stemming" (which is what you are talking about). But that is being worked into it. It might be supported by tonight (which is when I'll be working on it next). --Joe On Wed, Dec 13, 2000 at 03:01:33PM -0800, Robert V. Zwink wrote: > How do you handle plural words, ing ed endings and the like? This is my > current dilemea. > > Robert Zwink > http://zwink.levitate.org > > > > -----Original Message----- > From: Joe Stump [mailto:joe@earth.care2.com] > Sent: Wednesday, December 13, 2000 9:37 AM > To: Robert V. Zwink > Cc: php-general@lists.php.net > Subject: Re: [PHP] Search by "AND".... > > > This is how Miester Search does it - it makes a dictionary of unique words, > indexes the record against the dictionary by counting instances of a word in > each record. A more advanced scoring method is in the works as is the > ability > to index records on the fly. > > --Joe > > On Wed, Dec 13, 2000 at 10:25:15AM -0800, Robert V. Zwink wrote: > > How about counting the number of times the record contains the words, then > > use > > > > HAVING score >= ".count($keywords) > > > > The only problem is that you cannot have redundant words in you word index > > file. > > > > This is what a similar query looks like that I use: > > > > SELECT product.id, > > product.short_sku, > > product.coordinate_group, > > product.retail, > > product.inventory_location, > > product.deck , > > count(search_table.word) AS score > > FROM product, search_table > > WHERE product.id = search_table.qid > > AND (search_table.word IN('DISKETTES','COOL' )) > > GROUP BY search_table.qid HAVING score >= 2 > > ORDER BY score DESC LIMIT 0, 25 > > > > If this looks like what you are looking for, but doesn't make sense, let > me > > know and I'll try to explain further. > > > > Robert Zwink > > http://zwink.levitate.org > > > > > > > > > > > > > > -----Original Message----- > > From: Koo [mailto:koo@sun-scope.com] > > Sent: Tuesday, December 12, 2000 11:14 PM > > To: php-general@lists.php.net > > Subject: [PHP] Search by "AND".... > > > > > > I got two typical MySQL tables for fulltext search: > > > > table1 table2 > > ------ ------ > > wordID wordID > > itemID word > > > > where "word" holds all words > > ------------------------------------------------------ > > When I try to query the database for any items with > > EITHER wordA OR wordB, I do the following: > > > > mysql> select itemID from table1,table2 > > where table1.wordID=table2.wordID > > and (word like '%wordA%' or word like '%wordB%'); > > > > It works. > > > > But when I want query for any items which contain BOTH > > wordA AND wordB, the following query always outputs 0 rows. > > > > mysql> select itemID from table1,table2 > > where table1.wordID=table2.wordID > > and (word like '%wordA%' and word like '%wordB%'); > > > > Why? And what's the simplest way to accomplish my task? > > > > Many thanks. > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > --- > Joe Stump > PHP Programmer > www.Care2.com > --- Joe Stump PHP Programmer www.Care2.com