MySQL Forums
Forum List  »  MyISAM

Fulltext search problem!
Posted by: mahmud mofrad
Date: May 26, 2012 02:35AM

Hi,
The bellow code worked in mysql 5.0.24a But not work at mysql 5.5 !

$q is utf8 character.

SELECT *,MATCH(p.name,p.keywords) AGAINST('$q') AS pscore
FROM products as p
WHERE MATCH(p.name,p.keywords) AGAINST('$q') ORDER BY pscore DESC

please help me.
thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Fulltext search problem!
2564
May 26, 2012 02:35AM
1219
May 26, 2012 10:10PM
1114
May 27, 2012 12:07AM


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.