Devon, Try the methos outlines in this article:

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