in reply to How to do simple select with Net::MySQL

Just use qq instead of  q. from your example:
$mysql->query(qq{ select * from workspace where name = '$workspace' }) +;
qq{...} is the same as "..." while q{...} is like '...'
Boris