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