Something I didn't realize about full text searches, but they can be used
with multi-table views!
Maybe I'm the last one on the planet to discover this, but I think this is
really neat.
For example, I can create a view with all the fulltext index column of the
customer table (name, address, customer_profile), and link it to the
sales_summary table. Now I can search on our biggest customers this month
who live in Atlanta and like "fly fishing" so we can have a fishing derby.
It is fast too. I wonder why I didn't think of this before?
Am I the last one to discover this? Hmm. Anyway I thought I'd post it as a
tip in case someone else wasn't aware of it. Enjoy. :-)
Mike
(MySQL 5.1)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
