[FX.php List] Google-type search across tables?

[Tim 'Webko' Booth]

Dear Joel,
>
> Has anybody here implemented a "google-type" search across various  
> fields in multiple tables?  Any thoughts/recommendations?

I've certainly done it for multiple fields in one table, using a  
concatenated field.

I guess you could extend that for related tables, although working out  
which table actually has the end data might be interesting.

Or do multiple searches and aggregate the results, which may also  
allow for a score for relevance - but it would be inefficient due to  
the overhead involved in each search...

Just some thoughts

Webko