+ 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 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, April 13, 2004 9:32 PM > > To: [EMAIL PROTECTED] > > Subject: Mysql MAtch against query help > > > > > > I have a query that searches my database for > people > > with C++ on their resume . > > > > Query > > ===== > > select * ,match(Res_resume) AGAINST ('C++') as > > kewyordscore from member,memberprofile,resume left > > join stateprovince on stateid = Res_state > > where mem_id = mempf_memid and > > match(Res_resume) AGAINST ('+C++' IN BOOLEAN > MODE) > > > > I have the ft_min_word_len set to 2 , but for some > > reason , it still does not return a record when i > > search for C++. Is there a way to escape the ++ > when i > > do a search , or is there something i am not doing > > right. > > The query works when i do a search for 'PR' or > 'P*' . > > so i am sure that i reindexed my database. > > I am using Mysql version 4.1.1 on windows. > > Any help owuld be great ... thx > > > > Dave > > > > > > > > > > > > > > > > __________________________________________________ > > Do you Yahoo!? > > New DSL Internet Access from SBC & Yahoo! > > http://sbc.yahoo.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] > __________________________________ Do you Yahoo!? Yahoo! Small Business $15K Web Design Giveaway http://promotions.yahoo.com/design_giveaway/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
