my $csr = $dbh->sqlSelectMany("*", "company_contact_info", "region='San Diego'");

while(my $row = $csr->fetchrow_hashref())
{
  #row is now a single returned row that matched your query;
}

##</code><code>##

SELECT * FROM company_contact_info WHERE REGION LIKE "%San Diego%"