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]