Hi All,
I am new to this list, and will find it of excellent use to me.
I need help with the following:
What it is I have a cv database and it is working great, I use PHP and MySQL
and have just come across this problem, the client has asked me to search
lots of fields in the database. At
$SQL = SELECT * FROM cvtemplate WHERE employment_type = '$employment_type'
AND location = '$location' AND related_discipline = '$related_discipline',
MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, wxcdfour AGAINST
('$keywords') AS score FROM cvtemplate HAVING score!=0 ORDER BY
I'm having problems working with MATCH (a, b) AGAINST ('something')...
my query is:
SELECT name, MATCH (summary, description) AGAINST ('New York') AS
relevant_num FROM people;
I get the error message:
ERROR 1191: Can't find FULLTEXT index matching the column list
When I show index on the
Sorry, I figured it out... I need to create a FULLTEXT index on the
columns I want to search, then I have the "match" those columns in the
query.
:-)
I'm having problems working with MATCH (a, b) AGAINST