this question has answer here:
- how put string in array, split new line? 16 answers
i need here in gap have on piece of mysql. let's have made table in database, table contains text type field. within field there ten lines correspond ten different values. want example, call field (i have done this) want only fifth line! or each line separately anyway... have idea how this?
thank in advance!
as stated, not smell good. sounds lot data not normalised , you'd make life lot easier if did separate delimited values...
...however know it's not possible. have deal kind of thing (thanks decisions made using legacy technologies being perpetuated beyond control).
if stuck else's design decision, should trick:
http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/
edit: downvote without comment? nice...
Comments
Post a Comment