IN statement in MySql

The "IN" SQL keyword in MySql doesn't seem to work, atleast not in "PhpMyAdmin".

For example

select * from customers where customer_id in(select customer_id from costumers)

doesn't work in "PhpMyAdmin".
Does someone know why, and what should I do about it?

Because current MySQL doesn't support subqueries. IN works though. If you used

SELECT *
FROM customers
WHERE customer_id IN ('1','2','3')

It would work

Eugene,

The IN keyword is supported, but subqueries weren't supported until MySQL 4.1

hth, njm

Thanks, it helped :-)