Help for this page

Select Code to Download


  1. or download this
    # numbered:
    my $sth=$dbh->prepare('SELECT ... FROM ... WHERE SUBSTR(column, 1, LEN
    +GTH(:1)) = :1');
    ...
    my $sth=$dbh->prepare('SELECT ... FROM ... WHERE SUBSTR(column, 1, LEN
    +GTH(:what)) = :what');
    $sth->bind_param(':what', $what);
    $sth->execute();
    
  2. or download this
    my $sth=$dbh->prepare('SELECT ... FROM ... WHERE SUBSTR(column, 1, ?) 
    += ?');
    $sth->execute(length($what), $what);