MySQL: how to make multiple table fulltext search?

I think since full text search use some specific indexes you should separate table by OR.

I think since full text search use some specific indexes you should separate table by OR SELECT * FROM testtable t1, testtable2 t2 WHERE MATCH ( t1. FirstName, t1. LastName, t1.

Details ) AGAINST ( 'founder' ) OR MATCH( t2. FirstName, t2. LastName, t2.

Details) AGAINST ( 'founder' ).

– garcon1986 Mar 4 '10 at 10:27 your would have to copy the pattern multiple time – RageZ Mar 4 '10 at 10:58 @lexu: the error message is specific about the syntax in the against not being correct. If mysql would have ran crazy I would have bet like you ;-) – RageZ Mar 4 '10 at 11:00.

AGAINST('founder initiator employee'); or you can use boolean mode with more good stuff.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.