IN clause

[Mark Neil Borromeo]

been having problems can't find the exact phrase from the MySQL Documentation about the syntax. Anyway, one of the guy from asp.net forum ask some unusual question. I encounter this before and I don't want this to be a burden when I have this problem when using MySQL.

In this, I use world.sql (sample db) from MySQL sample db's.

tried to execute this one (we need to test something. just made up something like this one):

SELECT Name FROM city GROUP BY Name HAVING MAX(`Population`) > 10000 LIMIT 20;

after that, we need to execute something like

DELETE FROM city WHERE Name IN(SELECT Name FROM city GROUP BY Name HAVING MAX(`Population`) > 10000 LIMIT 20);


Well, we can see a helpful message. :)
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

thought of something to have the same.. and my last bet is to have a single line. like:

DELETE FROM city WHERE Name IN('name1', 'name2', 'name3');

Anyone would like to share some of their ideas?

Cheers,