Simple Question: MySQL and Shell Scripts

[Zach]

I am writing a shell script using Born Shell. I am trying to get the result of a SQL 
statement into a variable. 

For example:

/usr/bin/mysql -uroot -prootpass BOB << EOF
SELECT * FROM Bobstable WHERE Name=1
EOF

How do I get the result into a variable?

Thanks in advance!