> hmm well sorry to be unclear i know this works but it would return more > results than needed also i cant expect users to add this themselves, like i > would have to add the astrerix to every word in that case like i do to get > all words ;\
I don't know the MySQL issues (I'm now using some FULLTEXT indexes but haven't played with them yet). Note that the issue you're talking about is one of "stemming". The most common examples are singular versus plurals. One solution (if the built-in MySQL stuff proves unsatisfactory) is to build your own stemmer (assuming you're building some kind of interface to MySQL, using the MySQL API). -S > > -----Original Message----- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 19, 2003 7:41 PM > To: [EMAIL PROTECTED] > Subject: Re: punctuation in fulltext searching > > > Daniel Rossi <[EMAIL PROTECTED]> wrote: > > Hi i have just come across an issue where a word is not being searched up > if there is any punctuation ie. AMROZI'S will not be search upon if you type > AMROZI , please help > > Take a look at * operator which you can use in BOOLEAN MODE. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > -- > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
