Is there any way to override this functionality? It becomes a real pain, I have to start doing weird stuff to overcome this limitation, if it would just return the results whether its more than 50% or not, I would be fine. Is there no way to do this? Thanks.
Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox http://www.pacificfox.com.au an industry leader with commercial IT experience since 1994 . * Web Design and Development * Accept online Credit Card payments www.commerceengine.com.au * SMS Solutions, including developer API * Domain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years! -----Original Message----- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Thursday, 22 June 2006 2:07 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: Full-Text problems It's not necessarily the word appearing in more than 50% of thre records. If you search result returns more than 50% of the records, mysql considers the result irrlevant and doesn't return anything. You can kind of test it by using LIKE. SELECT count(*) from table where field like "%dealer%" or field like "%contact%" Remember, by default full text will find records that contain any of the words you are searching on. If you want to find only records that contain all the words, you need to do full text boolean search. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
