query with sub-query in where clause

[ahahahahahah]

I have problems with folowing query:

&quot;SELECT example FROM example WHERE example < (SELECT example FROM example)&quot;


I know these kinds of query's are possible in other sql related databases but is it possible in MYSQL?
Or do I use the wrong command for mysql?

Thank You
Maxime

 

[sleipnir214]

That query will not work with MySQL.

For limits on subselects in MySQL as well as workarounds, please point your browser here:

http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[swampBoogie]

Not supported in Mysql.

What are you trying to accomplish?