Execute unix command for each row returned by a query

[Nombre Apellido1 Apellido2]

Hi guys,

We're preparing an Unix script to be executed once a day.

It has to make a query to a MySql database. The output of the query is as following:

Email Commerce_URL
------ -------------
[e-mail] big-shop.com
[e-mail] walmart.us
[e-mail] tradecenter.com


The command for executing the query is as following:
mysql -u USER -p PASSWORD -h MYSQLSERVERNAME -e 'SELECT u.email , v.commerce_url FROM `users` u, `vendors` v WHERE (DATE(u.created) + 0 = DATE(NOW()) - 1 AND u.vendor_id=v.id AND u.vendor_id IS NOT NULL)' database-name


Therefore, for each row returned by the query, it has to send an email to the recipient specified in the Email column and write the link specified in the Commerce_URL column in the body of the email.

I mean something like that:

To: [e-mail]
Message:
Hi,
Thanks for registering at our service. You can visit us at big-shop.com

Kind Regards



Can you direct me to create such a script?

Thanks in advance