Hello. Has anyone been looking at using DBIx::FullTextSearch (or
indeed any other solution) for searching through multiple tables? I
have a "keyword" search, which needs to be able to match on pretty
much anything, since we don't know what criteria are going to be
entered into the search box.
(Yes, I know that this is likely to produce a lot of false
positives. Yes, there is a much more specific/guided/categorised
search elsewhere on the site.)
The kludge I have at the moment is to perform a fulltext search for
each individual search term and then munge the results together
appropriately, but maybe someone's come up with a better way to do it?