How to Select a Subset in MySQL. The Structured Query Language, used in the MySQL database, has great flexibility for selecting subsets of data from database tables.