Hello. MySQL doesn't support sub-queries (yet). See the following page for more information and also for hints how to work without sub-queries: http://www.mysql.com/doc/M/i/Missing_Sub-selects.html I never used full text search before, so I might miss something, but a starting point for your query should be: SELECT l.arx_id, MATCH (l.arx_xml) AGAINST (r.arx_xml) AS arx_xmlscore FROM arx AS l, arx AS r WHERE r.arx_id = 827 ORDER BY r.arx_xmlscore Bye, Benjamin. On Fri, Aug 03, 2001 at 11:48:49AM +0100, [EMAIL PROTECTED] wrote: > > I'm trying to do a match to find related xml documents against a document... > in this table arx_id is an autonumber column > > SELECT arx_id, MATCH (arx_xml) AGAINST (=select arx_xml from arx where > arx_id = 827) AS arx_xmlscore from arx order by arx_xmlscore > > it throws an exception about the subquery in there (sorry if it's obvious, > I've never tried a subquery before) [...] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
