MySQL Forums
Forum List  »  Full-Text Search

problems with searches for 'c#' and 'c++'
Posted by: shaun merifield
Date: February 06, 2006 03:49AM

Hi guys,

I have created a parser for cv’s and am having problems retrieving records when searching using the keywords ‘c#’, or ‘c++’. I use a boolean full text search and if a cv contains the keyword it should be retrieved.

The query is…
Code:

SELECT cv.id, cv.candidate_id, MATCH (cv.cv_text) AGAINST ('C++') AS score FROM db.cv_test cv, fb.candidates_test c WHERE cv.candidate_id = c.id AND c.hide_from_search = 'N' AND c.active = 'Y' AND MATCH (cv.cv_text) AGAINST (CONVERT( _utf8 '+C++' USING latin1 ) IN BOOLEAN MODE) order by score desc

It is not a minimium letters problem as that is set to 2

But nothing is returned.
Any idea's / suggestions would be appreciated

Options: ReplyQuote


Subject
Views
Written By
Posted
problems with searches for 'c#' and 'c++'
3591
February 06, 2006 03:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.