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.

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=gcdmg-mysql-2@m.gmane.org

RE: Full Text Searches

>-----Original Message-----
>From: mos [mailto:mos99@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=jschwartz@the-
>infoshop.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org