For all of the MySQL fans out there, there's a new press release you just might want to look at.

MySQL AB, developer of the world's most popular open source database, today announced a new version of the MySQL™ database that includes "subselects" and other enhancements designed to facilitate large-scale enterprise application development with MySQL.

MySQL Version 4.1 includes support for SQL subselects, also called subqueries or nested queries, a powerful feature that lets users search complex data with ease and efficiency. With subselects, users can achieve query consolidation by nesting one query inside another query, creating a resource otherwise unavailable for searching in a single statement. Subselects allow users to query within a result set, creatively limit the result set or correlate results with an otherwise unrelated query in a single call to the database.

Read more in the full press release here...