full text search- spped up searching

add fulltext search to speed up the searching in php

ALTER TABLE  $tablename ADD FULLTEXT(body, title);

$query = “SELECT * FROM $tablename WHERE MATCH(title, body) AGAINST (‘PHP’)  “;

This is uefull in very large data.

 

Only supperted by MyIsAM type.

Advertisement