in reply to Random Picks
Thank you all for your assistance with my problem.
I don't know how I missed such a simple and easy approach,
select * from table order by rand() limit 1000
especially after I read the Paul Dubois book on mysql. I will use this approach to complete my task but to further to my knowledge of perl I will try the other appoaches as well. Thanks again to all who responded.