Using MySQL Full-Text search with PHP

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? :slight_smile: