Here, a,b,d,e,f,u and v are variable length strings. delimiter '/ ' is constant.
On Fri, Jan 13, 2012 at 12:22 PM, Durga D <durga.d...@gmail.com> wrote: > Hi All, > > I have a table like this: > > h t0info ( h is primary key, t0info is unique) > --------------- > > 1 /a/d/u > 2 /a/e/u > 3 /a/f/u > 4 /a/g/v > 5 /a/b/c/d/e/f > > input is : /a > output should be: d, e f, g and b > > I am doing this way: select t0info from t0 where t0info like '/a%'; > > processing on string operations on result set to get d, e, f, g and b. > > any alternative solution for this? > > Thanks in advance, > Durga. > > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users