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]
