List:General Discussion« Previous MessageNext Message »
From:electroteque Date:April 13 2004 12:21pm
Subject:RE: Mysql MAtch against query help
View as plain text  
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 .
>
> 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/mysql?unsub=1

Thread
Mysql MAtch against query helpDavid Taiwo13 Apr
  • RE: Mysql MAtch against query helpelectroteque13 Apr
    • RE: Mysql MAtch against query helpHaitao Jiang13 Apr
Re: Mysql MAtch against query helpbeacker13 Apr