Re: Fulltext search - several tables

2002-05-29 Thread Victoria Reznichenko
Peter, Tuesday, May 28, 2002, 7:10:28 PM, you wrote: PE How can I do a fulltext search on several tables PE with just one SQL query? You can use full-text search in boolean mode on several tables without full-text index. SELECT * FROM table1, table2 WHERE MATCH(table1.column1,

Fulltext search - several tables

2002-05-28 Thread Peter Engström
Hello everybody! How can I do a fulltext search on several tables with just one SQL query? Best regards /Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Fulltext search - several tables

2002-05-28 Thread Peter Engström
Hello everybody! How can I do a fulltext search on several tables with just one SQL query? Best regards /Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Fulltext search - several tables

2002-05-28 Thread Peter Engström
Hello everybody! How can I do a fulltext search on several tables with just one SQL query? Best regards /Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Fulltext search - several tables

2002-05-28 Thread Gerald Clark
You will get better response if you post only once, and NOT as a reply to someone else's question. Peter Engström wrote: Hello everybody! How can I do a fulltext search on several tables with just one SQL query? Best regards /Peter