Dear members, Wish you a Happy New Year 2002 I created FullText Index and in the sql using 'where match(...,....,....) against ('searchstring')'. It is working fine for exact full words. How to operate for pharses i.e. The query should fetch even if the search string is substring of a column value. Is it possible. Thanking you yours Karthikeyan
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php