Indexes:
The PHP:
$search_terms = mysql_real_escape_string($_POST['search_prospects']);
$query = "SELECT * FROM `SALES_prospects` WHERE MATCH(`notes`) AGAINST('$search_terms')";
$qry_result = mysql_query($query) or die(mysql_error());
The error:
Can’t find FULLTEXT index matching the column list
Any ideas?