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
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

RE: Mysql MAtch against query help

2004-04-13 Thread electroteque
AIL 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+

Mysql MAtch against query help

2004-04-13 Thread David Taiwo
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)