> I have a string ("word word bob jack") such that I want to pass to the
> store proc as a single entity,
> split it in the store proc, and do a specific action for each word.
> Any
> advice on how to do this? There is more going on that just that
single
> word so multiple calls isn't practical and they string will have N+1
> elements so setting up a number of parameters is impractical (since
the
> word count may be as many as 1000).
>
I was able to create a loop based on the instr function and while.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
