Searching MySQL

[Anon]

Hi,

I'm trying to create a search engine in PHP that indexes a website and puts the keywords of the indexed website into a mysql field as a string - i.e. the whole string might be something like "computers,PHP,programming". How can I effectively search this? I've heard that you can use the LIKE statement in MySQL.
Another thing I'd like to know is how I can make this even remotely quick. Will I have to iterate through each row, extracting the string into an array of words then searching the array? I'm pretty sure this would be really slow...

Thanks,
Matt.

[Anon]

$items_found = 0;
$actual_search = htmlspecialchars(stripslashes($search));
$search = eregi_replace("[^{A-Za-z0-9#&/,} -]"," ",$search);
$search = eregi_replace("(^| )(at|in|if|is|on|by|the|this|or|for|of|to|be|from|etc|ll|and|but|re|ve|an| )+( |$)"," ",$search);
$search_array = explode(" ", $search);

$query = "SELECT term_id, term, definition  FROM glossary WHERE 0 ";
reset($search_array);
while($search_array_value = each($search_array)) {
	$item = $search_array_value["value"];
	if(strlen($item) > 1) $query .= " OR term REGEXP \"[[:<:]]".$item."[[:>:]]\" OR definition REGEXP \"[[:<:]]".$item."[[:>:]]\"";			
}
$query .= " ORDER BY term";
$result = mysql_query($query);