SQL "Entry" equivalent

Posted by jmls on 29-Jul-2011 14:29

Is there any SQL function / command to split a delimited string, or get the nth entry of such a string ?

All Replies

Posted by Thomas Mercer-Hursh on 29-Jul-2011 14:46

AFAIR, there is an equivalent of substring(), usually something like MID, I think, but not of entry() ... but it has been a while.

Posted by Admin on 30-Jul-2011 01:07

There is substring and locate that you can use but not as easy as using entry

However, why don't you split that on the client once you've got the result set?... oh, wait... you might want to filter on entry(n, field) because at some point someone though it wouldn't hurt if we put everything we didn't thought of when designing the database in a dummy super field and use comma as 'logical' field separator

This thread is closed