SONGS

SONGS

List songs in the catalog, optionally filtered by lyrics and written date.


Synopsis

SONGS [ WITH LYRICS("word1", "word2", ...) ] [ WRITTEN date_range ]
  [ ORDER BY sort_spec ] [ LIMIT n ];

Description

SONGS returns one row per song. Use WITH LYRICS(...) to require that lyrics contain all listed words, and WRITTEN to restrict by when the song was written. Use ORDER BY and LIMIT to sort and cap results.


Clauses

ClauseDescription
WITH LYRICS("word1", "word2", ...)Song lyrics must contain all listed words
WRITTENDate range when the song was written
ORDER BYSort field and direction
LIMITMaximum number of results

Examples

List songs (no filter):

SONGS;
SONGS LIMIT 50;
SONGS ORDER BY TITLE LIMIT 30;

Lyrics contain words (all must match):

SONGS WITH LYRICS("train");
SONGS WITH LYRICS("train", "road");
SONGS WITH LYRICS("rose") LIMIT 20;
SONGS WITH LYRICS("sun", "shine");

Written in a date range:

SONGS WRITTEN 1968;
SONGS WRITTEN 1968-1970;
SONGS WRITTEN 1970;

Combine lyrics + written + limit:

SONGS WITH LYRICS("rose") WRITTEN 1970 LIMIT 20;
SONGS WITH LYRICS("highway") WRITTEN 1969-1971 ORDER BY TITLE LIMIT 10;

Single word, no date filter:

SONGS WITH LYRICS("water");
SONGS WITH LYRICS("wheel");