full text search on multiple columns

[mehdi_php]

hi ,

i want to perform  fulltext search on to tables ( news , articles )

 

so i do that

1.

alter table xxnews add fulltext(xnewstitle , xnewsbody ) ;

2.

alter table xxarticle add fulltext(xarticletitle , xarticlebody ) ;

 

and try to search like this

select * from xxnews where match(xnewstitle , xnewsbody) against('test') 
union 
select * from xxarticle where match(xarticletitle , xarticlebody) against ('test') ;

 

but i got an error :the used select statements have different number of columns

i can't find the way to fix it . also this two table have no relation with each other .

i think fulltext search can be perform on multiple tables if they have relation with each other .

 

[Barand]

http://www.phpfreaks.com/tutorial/data-joins-unions

 

see section on unions