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
