From: Morgan Tocker
Date: August 22 2005 7:57am
Subject: Re: Search thru all fields in a table
List-Archive: http://lists.mysql.com/ug-brisbane/27
Message-Id: <45e8d20105082200575f46b320@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

> > Is there a shortcut way (rather than manually doing a SQL Statement for
> > each column), to search ALL columns in a table ?

> A FULLTEXT index can cover multiple columns.

My 2c followup on from Arjen's comment..=20

I used it in MySQL 4.0, but not since.  Does anyone know if it is any
faster now?  I had some slight performance issues though.  It says
speed improvements is still todo @
http://dev.mysql.com/doc/mysql/en/fulltext-todo.html.

FULLTEXT is probably nice when you are searching across so many (some
non relevant fields) as it has algorithmic goodness in it that makes
the more frequently occurring words have less weighting in the
relevancy fomula...  really handy.

It also has to common search engine +keyword -anotherword syntax.
See: http://dev.mysql.com/doc/mysql/en/fulltext-search.html


Cheers,
Morgan