M.I.T = Multimedia IT dept.

#!/bin/bash

day=$1
output=play.lst

cat > list.sql << EOF
use play;
SELECT sTime,slug,vid FROM playlist01 where sTime >= "$day 00:00:00" and sTime <= "$day 23:59:59" order by sTime;
EOF
#
mysql -h serverIP -u Username -pPassword < list.sql | sed 's/\t/;/g' | grep -v "sTime;slug;vid" > $output

--
REFERENCE: SELECT * FROM my_table WHERE name = "Smith AND age < 30;
http://twpug.net/docs/mysql323/manual_Tutorial.html