explode string sql

Hello all,

I have code sql:

SELECT sur_dokid FROM table1
WHERE sur_dokid IN ('1026, 1027, 1028')


I would like explode/divide string to array .
Example :
sur_dokid IN ('1026, 1027, 1028') convert sur_dokid IN (1026, 1027, 1028)
(In PHP code is: $array=explode(':','string1:string2:string3'); )

please help me.

janek wrote:
> Hello all,
>
> I have code sql:
>
> SELECT sur_dokid FROM table1
> WHERE sur_dokid IN ('1026, 1027, 1028')
>
>
> I would like explode/divide string to array .
> Example :
> sur_dokid IN ('1026, 1027, 1028') convert sur_dokid IN (1026, 1027, 1028)
> (In PHP code is: $array=explode(':','string1:string2:string3'); )

It's better you fix your database, create a table where you can have "one to
many" connections.

--

//Aho