Baron Schwartz schrieb: >> SELECT >> child.bookmark_id, >> child.bookmark_title, >> child.bookmark_url >> FROM >> bookmarks AS child >> WHERE >> child.bookmark_keyword IN ( >> SELECT >> parent.bookmark_keyword >> FROM >> bookmarks AS parent >> WHERE >> parent.bookmark_url = 'http://www.redhat.com' >> ) > > I would STRONGLY recommend AGAINST using subqueries in this manner. > MySQL optimizes this type of subquery very poorly, and I wouldn't even > "test" this query if the table is large -- it may kill the server. A > JOIN is the right approach here.
i don't think so -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
