Mysql ... versus plain type "% term%"

Question

What happened with:

$term = $_POST['search'];

function buildQuery($exploded,$count,$query)
{
   if(count($exploded)>$count) 
   {
      $query.= ' AND column LIKE "%'. $exploded[$count] .'%"';
      return buildQuery($exploded,$count+1,$query);
   }
   return $query;
}

$exploded = explode(' ',$term);
$query = buildQuery($exploded,1,
'SELECT * FROM table WHERE column LIKE "%'. $exploded[0] .'%"');

and then query db to get the results in a specific order instead of using myIsam-only sql match ... against?

Is this really going to hurt performance?

Answer 1

, MySQL , . . LIKE , . .

, , , - -, . , mysql_real_escape_string()

Answer 2

, MySQL University:

http://forge.mysql.com/wiki/Practical_Full-Text_Search_in_MySQL

:

http://www.slideshare.net/billkarwin/practical-full-text-search-with-my-sql

LIKE '%pattern%' 300 , MySQL FULLTEXT. 1,5 StackOverflow October.