Hi, I'm using MySQl 3.23.52 on RedHat Linux 6.2 I have a table that is indexed on the description column as FULLTEXT. I allow the user to enter text in an input field and I return matching rows. I've noticed that writing a query such as:
SELECT EDescript FROM HSCodes WHERE MATCH(EDescript) AGAINST ('books of paper'); will return all columns where any of the above words are found. What I want is to give the user a choice of: a) return matching columns where any words are found b) return matching columns where all words are found c) return matching columns where any part of any or all word(s) is/are found e.g.. 'ex' returns 'exercise' I've read the documentation and note that this is possible by using the IN BOOLEAN MODE clause but that I require MySQL 4.01 for this. As my system is a production database, I am hesitant to use a beta version. Am I out of luck or can this be simulated in 3.23.52? Thanks, Don --------------------------------------------------------------------- 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