partial string extraction with sql using regexp ?

hi all, Here's a nut to crack: I would like to extract a part of a string stored in a varchar column in a mysql table. Since the part of string I want to extract is neither at a fixed position nor logically separated by a fixed character I was thinking using regexp would by a good idea Sample d

partial string extraction with sql using regexp ?

hi all, Here's a nut to crack: I would like to extract a part of a string stored in a varchar column in a mysql table. Since the part of string I want to extract is neither at a fixed position nor logically separated by a fixed character I was thinking using regexp would by a good idea Sample d

building comma-separated list of strings from subquery

Hi y'all, I'ld like to accomplish something like: set @myvar=concat_ws(",",(SELECT column from table1 order by column; where ...)) or select concat_ws(",",(SELECT column from table1 order by column where ...)); for further usage in sql-scripts -- MySQL General Mailing List For list archive

RE: partial string extraction with sql using regexp ?

>I'ld like to accomplish something like: > >set @myvar=concat_ws(",",(SELECT column from table1 order by column; >where ...)) > >or > >select concat_ws(",",(SELECT column from table1 order by column where ...)); > >for further usage in sql-scripts I forgot to mention: As I need it in a function

RE: building comma-separated list of strings from subquery

>I'ld like to accomplish something like: > >set @myvar=concat_ws(",",(SELECT column from table1 order by column; >where ...)) > >or > >select concat_ws(",",(SELECT column from table1 order by column where ...)); > >for further usage in sql-scripts I forgot to mention: As I need it in a function, i