Any, some, all keywords in mysql

Any, some, all keywords in mysql
http://blog.csdn.net/imzoer/article/details/8266324

Any keyword:

Assume that the number of results returned by a query statement inside any is three,

So

Select ... where A>any (...)

-

Select ... where a > Result1 or a > result2 or a > RESULT3

All keyword:

The all keyword is similar to the ANY keyword except that the or is changed to and.

Some keywords:

The Some keyword and the Any keyword are the same functionality.

Any, some, all keywords in mysql