About field searchs

[henry_gayman]

I want to write "red green blue" in a text field and find out if a varchar() field in MySQL contains one-two or three of these words in it.. Words don't have to be in that order..
For example, a field with this text in it should be found:
-Green apple and red apple..

Like typing "word1+word2" at yahoo search.
Please reply,
Thanx

[henry_gayman]

Any ideas??.. not a single one??.. :mad: not a solution maybe but.. one little cute idea??
You dont know anything about SQL, isnt it? :mad:

[henry_gayman]

$string = "this is an example";
$tok = strtok($string," ");
while($tok)
{
echo "$tok<br>";
$tok=strtok(" ");
}
//echoes:
//this
//is
//an
//example

--i used this strtok() function to create this string-->
$searchword = "%this%is%an%example%";
--and it's enough to put it in a MySQL query like this one:
"select * from texts where data like '$searchword'"...
then my problem is solved,.. but not completely..
this search is not flexible like yahoo search style..
Haha, for a moment i thought i found the system of yahoo engine with writing 5 lines of code🙂 :p 😃