Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: mos (mos99fastmail.fm)
Date: Wed Mar 03 2010 - 16:14:11 CST
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
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. :-)
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql