WHERE surname LIKE ?
OR firstname LIKE ?
OR cardnumber LIKE ?
ORDER BY surname, firstname);
ORDER BY surname, firstname
my $sth = $dbh->prepare( $sql );
$sth->execute("$query%", "$query%", "$query%");
no: "Don't try"
- to guess the patron being entered while typing a patron search on the circulation screen.
- Only returns the first 10 results are returned at a time.
- pref: itemBarcodeInputFilter