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:chocolatesuperhero@stripped]
> Sent: Tuesday, April 13, 2004 9:32 PM
> To: mysql@stripped
> Subject: Mysql MAtch against query help
> I have a query that searches my database for people
> with C++ on their resume .
> 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
> 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
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: