[SOLVED] Full Text AND operator pulling up only first variable, is this right?

[HowdeeDoodee]

This select statement pulls records where only "peace", only "war", and both "peace" and "war" appear in the records. Isn't the AND operator supposed to pull only records where only "peace" AND "war" appear in the same record?

 

 

 

SELECT * FROM `View2_CondFT` WHERE MATCH(Topic, Subtopic, Theswords) AGAINST ('peace +war' IN BOOLEAN MODE) ORDER BY `Lnum` ASC

[HowdeeDoodee]

OK, I just ran an OR query and pulled up the same records with the same results. What gives?

 

SELECT * FROM `View2_ConcordFT` WHERE MATCH(Topic, Subtopic, Theswords) AGAINST ('peace war ' IN BOOLEAN MODE) ORDER BY `Lnum` ASC 

[Illusion]

Try this

WHERE MATCH(Topic, Subtopic, Theswords) AGAINST ('peace ' IN BOOLEAN MODE) AND MATCH(Topic, Subtopic, Theswords) AGAINST ('war ' IN BOOLEAN MODE) ORDER BY `Lnum` ASC ;

[HowdeeDoodee]

Thank you Illusion for the help. Much appreciated.