R: full text search on multiple tables

2008-01-09 Thread Nanni Claudio
'%..whatever..&' UNION SELECT "I'M A NEWS",ID_NEWS as ID_TO_RETURN FROM News T1 WHERE TITLE like '%..whatever..&' OR CONTENT like '%..whatever..&' Aloha! Claudio Nanni -Messaggio originale- Da: nikos [mailto:[EMAIL PRO

Re: full text search on multiple tables

2008-01-09 Thread nikos
That is a grate solution. The problem is that I must have deferent links for each response. That's the tricky thing! Thank you Sebastian Mendel wrote: nikos schrieb: Hello list I have to make a full text search and I want to do it in many tables. I have deferent tables for books authors and

Re: full text search on multiple tables

2008-01-09 Thread Baron Schwartz
On Jan 9, 2008 8:36 AM, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > nikos schrieb: > > Hello list > > I have to make a full text search and I want to do it in many tables. > > I have deferent tables for books authors and news. > > Any ideas how to do it? > > three separate queries or an UNION Or

Re: full text search on multiple tables

2008-01-09 Thread Sebastian Mendel
nikos schrieb: > Hello list > I have to make a full text search and I want to do it in many tables. > I have deferent tables for books authors and news. > Any ideas how to do it? three separate queries or an UNION -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql

full text search on multiple tables

2008-01-09 Thread nikos
Hello list I have to make a full text search and I want to do it in many tables. I have deferent tables for books authors and news. Any ideas how to do it? Thank you Nikos