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

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.


* Cal Evans
* The Virtual CIO

-----Original Message-----
From: Meltem Demirkus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 3:20 AM
Subject: [PHP-DB] search question

Is there any other efficient way (--except using LIKE)of searching a keyword
in mysql ...


PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to