ALTER TABLE articles ADD FULLTEXT(body, title);
<?php $query = " SELECT * FROM articles WHERE MATCH(title, body) AGAINST ('PHP') "; $sql = mysql_query($query); /* output results */ ?>