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.
This entry was posted on Saturday, March 26th, 2011 at 8:26 am and is filed under General. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
Connecting to %s
Notify me of follow-up comments via email.
Get every new post delivered to your Inbox.