Hello,

  Devon, Try the methos outlines in this article:
  http://phpbuilder.com/columns/clay19990421.php3

  The method is basically this:
  break up all your fields into one word chunks.
  insert into a search_table a chunk and it's corresponding
  ID of the row it came from.  It won't take boolean operations, but
  you could probably mod it to make it do it.  It is a nice design
  though because you can get a relevancy percentage thingy.  The only
  problem is that you have to run a maintenance script every day or
  hour to update the search terms.  The other option is of course the
  old OR field1 LIKE '%keyword%' OR field2 LIKE '%keyword', etc. etc.

-- 
Best regards,
 Jacob Singh
 Pajama Design 
 (413)582-9342
 2 Belanger Pl.
 Northampton, MA 01060

                        mailto:[EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to