Here's a select statement: SELECT Production_SRT.EVENT_DATETIME, CART.ARTIST, CART.TITLE, Production_SRT.LENGTH, CART.COMPOSER, CART.LABEL, EXT_LENGTH FROM `Production_SRT` LEFT JOIN CART ON Production_SRT.CART_NUMBER = CART.NUMBER WHERE (Production_SRT.EVENT_DATETIME BETWEEN "2014-09-23 11:50:00" AND "2014-09-23 12:10:59") AND (CART.GROUP_NAME = "MUSIC");
On Tue, Oct 28, 2014 at 4:17 PM, Mircea Paun <[email protected]> wrote: > Hello, > > Somebody can help me with more customization mysql query ? > I want to select by date (from .. to .. ) and I want to put one condition > (event types) > to have only music or traffic events in report. > My actual query : > --- > mysql -u user -p pass Rivendell -B -e "select EVENT_DATETIME, ARTIST, > TITLE, LENGTH, > COMPOSER, PUBLISHER, LABEL, EXT_LENGTH from \`Production_SRT\` order by > EVENT_DATETIME;" | > sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > PLAYOUT_RIVE.csv > --- > Tanks! > > mIRCea > > > _______________________________________________ > 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
