I edited my response. It was a typo. It was meant to say 'I will now research'

After reading on bash I can accomplish my mysql execution using a defined variable (variable = email address) but am not sure how to read a file and have the mysql execute the statement for each line (i.e. email) value.

Code:

#!/bin/sh

email="test@test.com"
table="contact_master"
column="subscribed"

qry="select id,data from $table where id in ($ids)"
qry="UPDATE $table SET $column='No' WHERE email=$email"

echo "Executing the following query"
echo $qry

/usr/bin/mysql -u root << eof
$qry
eof

I just dont know how to incorporate the awk statement that parses my emails and loop it into the above bash script which updates DB.