Android sqlite order by a substring

Asked May 13 '16 at 18:47

Active May 13 '16 at 18:47

Viewed 26 times

I'm trying to order this set of rows, by the last path segment:

_data: /storage/emulated/0/Pictures _data: /storage/emulated/0/Music _data: /storage/emulated/0/Notifications _data: /storage/emulated/0/Pictures/picture.png

The result I'm wishing to achieve is

Music Notifications Pictures picture.png

I've tried to play around with sqlite instr function but unfortunately Android sqlite doesn't contain instr(x,y,z), which would allow to fetch the last string after /. It only contains instr(x,y).

How may I achieve this behaviour directly from the database query?

asked May 13 '16 at 18:47

dwbrito

5,194
5
32
48

you can notice that you don't actually need to substr, since the prefix is always the same – njzk2 May 13 '16 at 18:50
@njzk2 in the sample it is the same, but the solution needs to be generic. – dwbrito May 15 '16 at 15:50

Android sqlite order by a substring

0 Answers0