MySQL Forums
Forum List  »  Full-Text Search

Full-Text Search not work in new version!
Posted by: mahmud mofrad
Date: August 20, 2012 05:56AM

my fulltext search query worked at mysql version 5.0.24a-community-nt But not work at new version mysql!

query is:

SELECT p.section_id,MATCH(p.title,p.keywords) AGAINST('$q' IN BOOLEAN MODE) AS pscore FROM products as p INNER JOIN companies as c ON AND AND MATCH(p.title,p.keywords) AGAINST('$q') AND p.published=1 ORDER BY p.score DESC

please help me.

Options: ReplyQuote

Written By
Full-Text Search not work in new version!
August 20, 2012 05:56AM
August 25, 2012 01:18AM

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.