RE: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread Gelu Gogancea
mysql.com Subject: Re: Split a Delimited String in SQL ( PROCEDURE split_string ) On Wednesday 21 June 2006 13:37, listsql listsql wrote: > Just for the happy comment: Argentina Will win the match tonight against > Holland :) > MARTIN ERROR 1064 (42000): You have an error in your SQL syntax

Re: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread Jørn Dahl-Stamnes
On Wednesday 21 June 2006 13:37, listsql listsql wrote: > Just for the happy comment: Argentina Will win the match tonight against > Holland :) > MARTIN ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t

RE: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread Logan, David (SST - Adelaide)
ay, 21 June 2006 8:36 PM To: mysql@lists.mysql.com Subject: Split a Delimited String in SQL ( PROCEDURE split_string ) Hi all, I was trying this: http://forge.mysql.com/snippets/view.php?id=4 That is supposed to emulate a split() in mysql. Could anyone make it work ? I've been trying w

Re: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread listsql listsql
Definitivaly stopping and going for one or two cups of coffee. I was logged in to another mysql... when I copied the last email. Sorry guys, I don't want to add extra non-sense text to the list! +--+ | version()| +--+ | 5.

Re: Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread listsql listsql
Sorry forgot to copy my version: It's not acepting the delimiter command, can be ? I'm really missing something here. +---+ | version() | +---+ | 4.0.24_Debian-10ubuntu2.3-log | +---+ mysql> de

Split a Delimited String in SQL ( PROCEDURE split_string )

2006-06-21 Thread listsql listsql
Hi all, I was trying this: http://forge.mysql.com/snippets/view.php?id=4 That is supposed to emulate a split() in mysql. Could anyone make it work ? I've been trying without luck. I 'm getting strange errors when trying to create this procedure. _ DROP P