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.

---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

Reply via email to