Column1 Column2 apple banana; cat dog; elephant flag; dog home banane kite and so on.... #### Column1 Column2 Column3 apple banana kite cat dog home elephant flag and so on.... #### my $sth = $dbh->prepare("INSERT INTO Test3 values (?,?)"); my $order1 = $dbh->prepare("SELECT Column1 FROM Test3 ORDER BY Column1"); $sth->execute($words[0],$words[1]) or die $DBI::errstr; $order1->execute(); while(@row = $sth->fetchrow_array()) { print qw($row[0]\n$row[1]\n$row[2]\n);} $sth->finish(); $order1->finish();