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 looks for table1.name is null. hth, Arthur
On Tue, Sep 15, 2009 at 6:52 AM, Mark Goodge <m...@good-stuff.co.uk> 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? > > Mark > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=fuller.art...@gmail.com > > -- Semi-retired SQL guru, interested in interesting projects not YAFOES (yet another order entry system).
