Thanks master, I have read the tutorial of trim() , strtolower() and explode().
explode() is very powerful, and my question is solved.

$newmatch = explode(" ",$newmatch); is the best way.
;D

Not sure exactly what you're asking but if you're wondering how to match fruit but not fruits (same with apple and apples) you can do this:

 WHERE name1 REGEXP '[[:<:]]fruit[[:>:]]' OR name1 REGEXP '[[:<:]]apple[[:>:]]'

LOOK AT REGEXP

It\'s hard to tell, but I think if you are trying to avoid returning anything that does not equal the exact word (apples != apple). You will have to break your $match string into smaller parts and check for them individually. maybe use explode() to break the string apart using white spaces and then do exact matches on the words that apply.

Currently, You are checking for any data in the database that could resemble the string in anyway whatsoever. So it could return \"pineapple is a fruit\" just because it has the words \"is\", \"a\" and \"fruit\".

It might also be worth it to rename your database columns. Nobody whats you look a code with name1,name2,name3.... how about type,name,color,amount?

$match = trim($match);
$match = strtolower($match);
$newmatch = explode(\" \",$newmatch);

So if $match was \"This is an apple\" $newmatch = array(\"this\",\"is\",\"an\",\"apple\")

Of course, this wont get rid of any punctuation. But you can do before hand if you like with trim and preg_replace.

Help: trim() , strtolower() , explode()