reverse for match() against() in mysql?

[SamudraSri]

hi everybody

i am working wamp since 4+ years. i have a requirement where in i need to search for the record that matches some keywords using fulltext

search.
tables:

temp1(id,keywor ds,searchin,mat chwords);
temp2(id,keywor ds,title)

my question is that i want to select
id from temp1 where match(temp1.key words) against('word1 word2...' in boolean mode)

word1, word2,.. are from temp2.keywords
if temp1.matchword s==1 then all words of temp1.keywords should be matched
if temp1.matchword s ==2 then any word of temp1.keywords should be matched

similarly if temp1.searchin ==1 then search in temp1.keywords
if temp1.searchin ==2 then search in temp1.title

so i want this to be done in one or two select statements

hoping that some one is going to solve or help in this regard

samudra sri

[mwasif]

Hi SamudraSri,

Welcome to TSDN!!!

Kindly do not post a question twice. I have deleted your other post.