$sth = $dbh->prepare( "SELECT * FROM `items` WHERE UPPER(description) LIKE UPPER(?) OR UPPER(longdescription) LIKE UPPER(?)"); $sth->execute($search,$search) or die $dbh->errstr;