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

Hi,
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 p.company_id=c.id AND c.active=1 AND MATCH(p.title,p.keywords) AGAINST('$q') AND p.published=1 ORDER BY p.score DESC

please help me.
thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Full-Text Search not work in new version!
3990
August 20, 2012 05:56AM
3225
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.