Help for this page

Select Code to Download


  1. or download this
    "SELECT rec,id from memrecs where rec collate latin1_bin rlike '[A-Z]'
    +" );
    
  2. or download this
    $dbh->do( "UPDATE memrec set rec=LOWER(rec)" );
    
  3. or download this
    if ( $_rec =~ /A .. Z/) {
        $_rec =~ tr/A-Z/a-z/g;
        ...
    }
    
  4. 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
    }