Re: Mysql MAtch against query help

2004-04-13 Thread beacker
>> I have a query that searches my database for people >> with C++ on their resume . ... >Hehe I've also had a problem with searching for something like it's , >anything with a single quote doesnt return anything, maybe try adding a >slash , C\+\+ ?? heheh maybe i'm wrong, it could be a limitation.

RE: Mysql MAtch against query help

2004-04-13 Thread Haitao Jiang
+ is not part of the definition of a word in MySQL. One solution is to normalize "C++" into "CPLUSPLUS" both during index and query time. Haitao --- electroteque <[EMAIL PROTECTED]> wrote: > Hehe I've also had a problem with searching for > something like it's , > anything with a single quote doe

RE: Mysql MAtch against query help

2004-04-13 Thread electroteque
Hehe I've also had a problem with searching for something like it's , anything with a single quote doesnt return anything, maybe try adding a slash , C\+\+ ?? heheh maybe i'm wrong, it could be a limitation. > -Original Message- > From: David Taiwo [mailto:[EMAIL PROTECTED] > Sent: Tuesday