>-----Original Message----- >From: mos [mailto:mo...@fastmail.fm] >Sent: Wednesday, March 03, 2010 5:14 PM >To: mysql@lists.mysql.com >Subject: Tip: Full Text Searches > >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. > [JS] I never did it with a view, I just did it with a join.
Works fine, lasts a long time. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com >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=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org