and once again, according to the mysql doco, you need version
4.1.x or better to use subqueries
Dean
Del wrote:
*delete** from members_temp where email like '(select distinct email
from news)' *
Answer 2: remove the quotes.
delete from members_temp where email like (select distinct email from news)
Otherwise you're trying to delete a member who has the email address
"(select distinct email from news)" which is a very odd email address.
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
