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,
   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

Written By
September 16, 2009 09:25AM
October 23, 2009 01:00AM
Re: MATCH AGAINST on two tables
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.