MySQL Forums
Forum List  »  Full-Text Search

Re: Problem with full-text search order by with UNION
Posted by: Rick James
Date: December 04, 2008 09:17PM

1. Don't have an answer to your question.

2. Workaround: Put the results into TEMPORARY tables, then UNION them.

3. IIRC, relevance in one table is not comparable to that in another. Hence, the final results may (or may not) be in the desired order.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem with full-text search order by with UNION
3892
December 04, 2008 09:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.