best way to query multiple searchs --was bind_param and mysql

> I must admit that I do not understand what you really have in mind
> with"a search for multiple strings". If you are referring to
> specific MySQL
> features, could you please be so kind and provide a pointer to the
> relevant docs?

maybe if I explain what i'm trying to do. I have a hash that has 4 strings for which I woudl like to search. Typically I would just do a SELECT * FROM table WHERE $1 OR $2 OR $3. However I wish to set up a ruitine that will automatically search for any given number of variables. reading the DBI book fromO'Rielly it pretty much says running a query for each variable via a loop then adding the result to an array is not efficient. I'm told bind_param is a better way this should allow me to Select each string via a loop. Then do one single fetch_all for all the results. However perhaps I m misunderstanding the use of bind. what would be the best way to approach this problem.


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org