if ($input) { my $search = $DBH->prepare("SELECT * FROM tble WHERE CONCAT(NAME, ', ' +, AGE, ', ', COUNTRY) LIKE ?"); $search->execute('%'.$input.'%'); my $row; while (my $row = $search->fetchrow()) { print "$row\n"; } } #### Jane Deo John Deo #### ------------ John Deo HTML DIV------------
$scal #John Deo
Edit Name ------------ John Deo HTML DIV END ------------ ------------ NEXT IS JANE DEO HTML DIV -------- ------------ END OF JANE DEO -------------------