Re: punctuation in fulltext searching
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]
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]
RE: punctuation in fulltext searching
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 ;\ -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]
