Simon Willison’s Weblog


MySQL adds subselects

27th January 2003

MySQL Adds Subselects, Upgrades Performance and Security:

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.

This is MySQL adds subselects by Simon Willison, posted on 27th January 2003.

Next: Letter to the editor spam

Previous: Adequacy gone

Previously hosted at