I ca try that one too. Since, I'm bad with reg expressions, what would be solution for something like "match searched word and it's plural - if one word entred, or match all words - if more words entered"?
thanks -afan > 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]