All pastes #583809 Raw Edit

Someone

public text v1 · immutable
·published 2007-06-22 14:59 UTC
rendered paste body
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)) {