- or download this
"SELECT rec,id from memrecs where rec collate latin1_bin rlike '[A-Z]'
+" );
- or download this
$dbh->do( "UPDATE memrec set rec=LOWER(rec)" );
- or download this
if ( $_rec =~ /A .. Z/) {
$_rec =~ tr/A-Z/a-z/g;
...
}
- or download this
if ( $_rec =~ tr/A-Z/a-z/ ) {
# tr/// returns the number of characters converted
# so we get here only if there had been at least one A-Z
}