MySQL Forums
Forum List  »  Full-Text Search

Re: MATCH AGAINST on two tables
Posted by: Rick James
Date: November 29, 2009 04:29PM

Eh? You want substrings? Or was that a poor example of what you are after?

To get all the rows you specify:
SELECT a.aname,
       b.bname
   FROM a, b;
You might be able to add to that
MATCH(aname) AGAINST ('...') +
MATCH(bname) AGAINST ('...') +
but I don't know what strings you are looking for.

Options: ReplyQuote


Subject
Views
Written By
Posted
10579
September 16, 2009 09:25AM
4183
October 23, 2009 01:00AM
Re: MATCH AGAINST on two tables
3787
November 29, 2009 04:29PM


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.