This is the Indexes.... | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | regions | 0 | PRIMARY | 1 | id | A | 26909 | NULL | | | BTREE | | | regions | 1 | search_index | 1 | region | | 1 | NULL | | | FULLTEXT | | | regions | 1 | search_index | 2 | town | | 1 | NULL | | | FULLTEXT | | | regions | 1 | search_index | 3 | county | | 1 | NULL | | | FULLTEXT | | +---------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ I'm using this to return it... but it returns nothing. $resultA=mysql_query("SELECT * FROM regions WHERE MATCH (region,town,county) AGAINST ('Scotland') limit 0,1000"); while($resultRowA = mysql_fetch_array($resultA)) {