Why not try regex? http://dev.mysql.com/doc/refman/4.1/en/regexp.html
On 4/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi to all, > I have to build a search of products on web catalog site. It has to search > a whole words to avoid when somebody search for a pin and get "*pin*k > shirt". > I was suggested to use MATCH() AGAINST() and it works perfect - until I > dscovered that I'm getting alwayes 0 results if search for cap, pen, mug - > three-letter words. Since, these are one of the most searched words (we > are in promotin industry) it's a big problem for me. > I found on http://dev.mysql.com/doc/refman/4.1/en/fulltext-boolean.html > that the default value of minimum character length is 4?!?!? > > Does anybody solved this problem? > is there any other solution to suggest? > > Thanks for any help. > > -afan > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]