DBD::mysql::st execute failed: Unknown column 'AR_email' in 'field list'
以下是查询:
my $q = "SELECT SUBSTRING(AR_email, LOCATE('@', AR_email) + 1) AS domain
FROM carrier
WHERE AR_email IS NOT NULL
AND SUBSTRING(AR_email, LOCATE('@', AR_email) + 1) =?";
my $sth=$dbh->prepare($q);
$sth->execute($domain);
