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