rendered paste bodyThis 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)) {