Re: MySQL full text search multiple tables

2003-09-09 Thread Matt W
x27;m not sure that the join is done using the id index. :-( I think a full scan may be done on table2. This is very bad if table2 has a lot of rows. Matt - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, S

Re: MySQL full text search multiple tables

2003-09-09 Thread Victoria Reznichenko
Steve Radabaugh <[EMAIL PROTECTED]> wrote: > > I have been exploring MySQL's full text search feature and have not been > able to find any information on querying a full text search across > multiple tables. Do you have to make recursive queries to each table? You can't create fulltext index on

MySQL full text search multiple tables

2003-09-08 Thread Steve Radabaugh
Greetings, I have been exploring MySQL's full text search feature and have not been able to find any information on querying a full text search across multiple tables. Do you have to make recursive queries to each table? Thank you in advance, Steve Radabaugh -- MySQL General Mailing List For li