mysql select query using an array of key words

[Jlwalm]

I would like to create a query that queries a database using an array containing key words. The query will select all the records that match any word in the array.

I don't have any idea how to do this and am hoping someone can point me in the right direction.

many thanks

Jlwalm

[BioBob]

SELECT * FROM db WHERE field NOT IN ('apple','orange','banana');

 

I think that will work...

[JasonLewis]

mysql_query("SELECT * FORM table WHERE column_name IN (" . implode(',', $array) . ")");

 

Something like that? Google "MySQL IN".

[Jlwalm]

sorry, I forgot to mention.

The array will need to be either in a text file or in another database table.

thanks

[trq]

So you need help creating the array aswell then?

[Jlwalm]

yes, I need help with keeping some key words in a table and using an array to find out which of those key words exist somewhere in another table.

thanks