string search

sol01

I have the following selct statement.

$query is my search string

$result = mysql_query("SELECT * from data WHERE (table like '%$query%') OR (table like '%$query%') OR (table like '%$query%') OR (table like '%$query%')");

If I have an article like:

I have a red dog and she likes to bark loudly

and I search for the word dog I get it fine but if I search for:

pink fat dog

I get no results. I believe my search query searches for the string "pink fat dog" and doesn't take the individual words into account.

Thanks for your help in advance.

Anon

$result = mysql_query(\"SELECT * from data WHERE (table like \'%$query%\') OR (table like \'%$query%\') OR (table like \'%$query%\') OR (table like \'%$query%\')\");

that seems a little redundant, you are checking for the same argument 4 times. I think what you\'re trying to do is search for the individual arguments, like query[1], query[2] etc. That probably isn\'t the right syntax but you get what I mean 😛

Anon

For that, you first have to cut the query string. Try the following:

$ArrayOfWords = explode(" ",$TheQueryString);

Then in your case, $ArrayOfWords would contain the following:

$ArrayOfWords[0] = "pink";
$ArrayOfWords[1] = "fat";
$ArrayOfWords[2] = "dog";

Then, you can extend the query using these parameters. Take a look, thought, that there must only be one space between words, or else, one of the array elements might contain an empty value, and, when making a query with LIKE an that argument... it would be a query like this:

SELECT field FROM table WHERE field LIKE '%%'

And that returns all of the records in the table. Try to check if any of the values from the Array is equal to nothing,m and, if so, don't use it as an SQL criteria.

Hope this helps

fLIPIS

sol01

Do you have a working example or script for this?

Do I need to do more then one select query?

$ArrayOfWords[0] = "pink";
$ArrayOfWords[1] = "fat";
$ArrayOfWords[2] = "dog";

Something like this:
SELECT * from company_data WHERE (comp_name like '%$ArrayOfWords[0]'. '%$ArrayOfWords[1]%', '%$ArrayOfWords[2)%')

?????????

thanks for the help.