You may be able to get what you need with three queries. Join the tables on
the column of interest. By default you'll get a list of the matches. Then
you can modify the join by adding a WHERE clause that looks for
table2.nameis null, and again by modifying the WHERE clause so it
table1.name is null.
On Tue, Sep 15, 2009 at 6:52 AM, Mark Goodge <mark@stripped> wrote:
> John Furlong wrote:
>> My question is, can the argument in AGAINST() refer to a column in
>> another table or does it have to be a specific string you are
>> searching for? If the MATCH() function won't work, any suggestions
>> on how else to compare table1.name against table2.name? The columns
>> are defined as VARCHAR.
> Does anyone have an answer to this? I, too, would like to know how to use
> fulltext to compare data between two columns (as opposed to comparing data
> between a column and a pre-defined string). Is there any way to do this?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Semi-retired SQL guru, interested in interesting projects not YAFOES (yet
another order entry system).