$dsn = "DBI:mysql:database;db.database.com"; $dbh = DBI->connect($dsn,'user','pass'); $sth = $dbh->prepare("SELECT * FROM company_contact_info WHERE region = '%San Diego%' ";"); $sth->execute();