MySQL Forums
Forum List  »  MySQL Query Browser

Re: match - against
Posted by: Miguel A. Villar
Date: January 11, 2012 11:26AM

Hi, my problem is that I can not use match - against. I have mysql 5.5 and when sending the following query:

$query = "SELECT ID, name, inicio FROM db.notas_calendario WHERE miembroID=".$_SESSION['userID']." AND MATCH (`name`, descripcion) AGAINST ('".$_POST['cadena']."' IN NATURAL LANGUAGE MODE) ORDER BY inicio ASC";

it arises an error.

In fact, i use Navicat Premium 9.1.7 and the AGAINST word is not recognized. Navicat show the next error: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NATURAL LANGUAGE MODE) ORDER BY inicio ASC' at line 2"

What's wrong?

Options: ReplyQuote


Subject
Written By
Posted
December 21, 2011 03:49AM
Re: match - against
January 11, 2012 11:26AM


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.