Re: Searching a table

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:junk@balances.com