As of Rivendell 2.10.3, a valid SQL statement to search the CART table by year would look something like:
select NUMBER,GROUP_NAME,TITLE,ARTIST,ALBUM,YEAR from CART where YEAR like '1990%'; Note the year format "YYYY-MM-DD". This is because YEAR uses the MySQL "date" data type which includes the month and day. MM and DD default to 01 when not specified, but using the "LIKE" comparison operator gets you all rows that match the year 1990. Hope this helps! ~David Klann On 08/15/2016 08:12 AM, Morten Krarup Nielsen wrote: > Hi. > > We need to find songs from 1991, 1992 and so on. We have entered the > data in RdLibrary, but you can't search for it :-( > > Is there anyone that now the SQL command to find songs from a specific year? > > Thank you! > > Kind regards, > > Morten > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
