Advanced keyword search with keyword list in an array

[Raghavendra N]

Hi all,

I am implementing advanced search on a MySQL table.

I get the keywords in separate arrays:

allKeywords = []; //use all keywords from this array
exactKeyWords = []; //use exact phrase from this array
noKeywords = []; //Not operator

In my previous assignments I've used full-text searches like this:

SELECT * FROM report WHERE MATCH (title,toc,overview,meta_keywords)
AGAINST ('+surgical "growth rate" -operations' IN BOOLEAN MODE);

Now I need to pass the keywords in arrays. Can any one help how I turn the above query to accomodate array variables.

If you can site a tutorial or example that will also help me.

Thanks a lot,