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

Reply via email to