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]