UNION in Volltextsuche, Wo bleibt die Relevanz? (MySQL4.1)

[Mario]

Hallo,

Du meinst also so?, ich probier das gleich mal.

SELECT col1_in_tab1, MATCH (col1_in_tab1) AGAINST('text') as ORDER
FROM tab1 WHERE MATCH (col1_in_tab1) AGAINST('text')

UNION

SELECT col1_in_tab2, MATCH (col1_in_tab2) AGAINST('text') as ORDER
FROM tab2 WHERE MATCH (col1_in_tab2) AGAINST('text')

ORDER BY ORDER

Gruss, Mario