From: Parna
Date: April 17 1999 10:23am
Subject: A Query!
List-Archive: http://lists.mysql.com/mysql/2063
Message-Id: <3718612F.5FC71D1C@usa.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Everybody,
      I want to create a query of the following type:
     I have a field in a table of type varchar(50). Now I have few words
to search for. I want to do the search for all the records such that in
its above field the record has atleast on matching word. Besides this I
also want to know how many words were found in the field for each
record. Can this be done in a single query? and How?

Thanx in adv.

Parna