Thanks, I will give it a try today!
2016-08-15 16:08 GMT+02:00 David Klann <[email protected]>: > 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 >> > _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
