Search the Brave New Waves playlist database
(about this page | simplified search)

Enter an SQL SELECT query:
(see examples below)


The table is called playlist and the columns (i.e. fields) are as follows: 
+-------------+--------------+
| Field       | Type         |
+-------------+--------------+
| programdate | date         |
| artist      | varchar(200) |
| tune        | varchar(60)  |
| duration    | time         |
| recformat   | varchar(10)  |
| rectitle    | varchar(60)  |
| spine       | varchar(25)  |
| cutnum      | varchar(15)  |
| relyear     | year(4)      |
| label       | varchar(40)  |
| position    | int(11)      |
+-------------+--------------+

Some Examples:

To find all tunes with "aislers set" in the artist field:

The * character means that all the columns in the table will be displayed. The search is case-insensitive. Don't forget to use the % wildcard symbol at the beginning and end of the search string if you want to match substrings! (For example, use '%aislers%', not 'aislers'.)

To find all tunes with "shocking" in the rectitle (Recording Title) field:

To show all tunes played on 1 May 2001 in the order in which they were played:

To list all playlists from May 2001:
(We only want to display the programdate column, so we specify SELECT programdate instead of SELECT *. We must use GROUP BY programdate, otherwise we will get one row per matching tune instead of one row per matching program date.)

To list all live recordings present in the database:
(We only display the above five columns, because the other columns are blank for live recordings.)

To list all the distinct recording titles played in April 2001, and the number of (not necessarily distinct) tunes played from each:
The number of rows returned gives the number of distinct recording titles played in April 2001. (More precisely, the number of distinct (artist, recording title) pairs.)

To list the "top 50" record labels in 2000 (ranked by the number of (not necessarily distinct) tunes played from each record label):

etc.

If you need help putting together a specific query, post a question on the BNW message board and I'll see what I can do.

For details on the SELECT command syntax, see the MySQL documentation (e.g. Retrieving Information from a Table, Examples of Common Queries, SELECT Syntax).

I know this isn't very user-friendly, but I didn't want to make a separate web form (with scrollable lists, drop-down menus, radio buttons, and check boxes) for every possible type of query.