Database multitable and/or multicolumn search

Bill,

There are two directions you could go with this, you could go strictly
SQL and use the EZWhere plugin to help you build the SQL or you could
go with an index search engine using the Ferret plugin. Personally I
think I would go with Ferret, but I am already familiar with Lucene
(which Ferret is based on).

Just two ideas, I am sure others will have more. Good luck!

Carl

Bill,

When you say fulltext search, that really points to using Ferret,
especially if you want to avoid using database specific features. I
believe most of the modern databases all have some type of fulltext
search built in. I know Oracle does, you told me MSSQL does. Google
would have the answer for the others.

However, your many emails problem can be solved by normalizing your
database and putting those fields into their own table that has a
foreign key back to the table they belong to.

Carl