# Using MySQL Full-Text search with PHP

**URL:** https://forum.kirupa.com/t/using-mysql-full-text-search-with-php/222772
**Category:** programming
**Created:** [April 16, 2007, 8:54pm UTC](https://forum.kirupa.com/t/using-mysql-full-text-search-with-php/222772 "2007-04-16T20:54:40Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![ratherblue](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ratherblue/32/2052_2.png) [@ratherblue](https://forum.kirupa.com/u/ratherblue)
#### Post date: [April 16, 2007, 8:54pm UTC](https://forum.kirupa.com/t/using-mysql-full-text-search-with-php/222772/1 "2007-04-16T20:54:40Z")

</div>

Indexes:

![](http://www.seventhstorm.net/indices.jpg)

The PHP:

```auto
$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? 🙂