mysql: fulltext index

to create a fulltext in mysql

# make sure your table is a MYISAM table
ALTER TABLE maps ENGINE = MYISAM;

# create a fulltext index on your column
CREATE fulltext INDEX idx_name ON tablename(columnname);

# to search
SELECT * FROM tablename WHERE MATCH(columnname) AGAINST("+word1 +word2" IN BOOLEAN MODE);