You could check out the FULLTEXT searching in MySQL, too. It's in the manual. It has some quirks, but works well on a large database.
Advertising
---John Holmes... > -----Original Message----- > From: Cal Evans [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 8:04 AM > To: Meltem Demirkus; [EMAIL PROTECTED] > Subject: RE: [PHP-DB] search question > > it depends on how you design your database. When I know I will have this > situation, I design a table named keyWords. Put one work per record and > assign each word an ID number. Then I create a join table between > keyWords > and whatever table they relate to. The join table only contains 2 fields, > the pk from keyWords and the pk from the other table. Then I ad 1 record > to > the join table for each keyword that relates to each record in the other > table. > > It's simple then to join the 3 tables in such a manner as to quickly find > the records in the other table that relate to a specific key word. > > HTH, > =C= > > * > * Cal Evans > * The Virtual CIO > * http://www.calevans.com > * > > > -----Original Message----- > From: Meltem Demirkus [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 3:20 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] search question > > > Hi, > Is there any other efficient way (--except using LIKE)of searching a > keyword > in mysql ... > > thanks > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
