Full-Text Search not work in new version!
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.
Subject
Views
Written By
Posted
Full-Text Search not work in new version!
3990
August 20, 2012 05:56AM
2300
August 22, 2012 10:56PM
2144
August 23, 2012 12:28AM
2325
August 23, 2012 07:52PM
2299
August 24, 2012 03:58AM
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.