Petition – Help saving MySQL – II
Kedar
And I looked back and thought of updating this post… Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview,…
32 responses to “MySQL Stored procedure – Split Delimited string into Rows”
thanks for the procedure it worked for me
Good code! Very elegant and easy to use.
I thanks a lot for your code, works perfect.
Thank you very much, it was of great help 🙂
HI
I have ran your code in my environment but when i try to call the sp it showing #1305 – PROCEDURE split_string does not exist.
Can you please help me on this
Since you are dealing with strings, I would use CHAR_LENGTH() instead of LENGTH() to also serve multi-byte characters. Otherwise your procedure can mess up the string lengths of various languages with special characters.
i want to split the string include the delimiter how to help can anyone suggest the query