mysql FULLTEXT搜索多个单词

mysql FULLTEXT搜索多个单词

$sql = mysql_query("SELECt * FROM          patient_db WHERe          MATCH ( Name, id_number )          AGAINST ('+first_word +second_word +third_word' IN BOOLEAN MODE);");

如果要进行精确搜索：

$sql = mysql_query("SELECt *        FROM patient_db        WHERe MATCH ( Name, id_number )        AGAINST ('"exact phrase"' IN BOOLEAN MODE);");