Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
executable file 22 lines (12 sloc) 548 Bytes
#!/bin/bash
MYSQL="mysql -u craig -pwilliam -D craig"
if [ $# -ne 1 ]; then
echo "What date to caculate ? like: 2010-06-16, or 2010-06-18."
exit;
fi
date1=$1
$MYSQL <<- __EOT__
select count(distinct email) as "$date1's emails (USRESUMES):" from craigslist_usresumes where date like '$date1%';
select count(distinct email) as "$date1's emails not @craigslist.org (USRESUMES):" from craigslist_usresumes where date like '$date1%' and ( email !='' and email not like '%@craigslist.org%' );
select "";
__EOT__