> 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]