Android sqlite order by a substring
<p>I'm trying to order this set of rows, by the last path segment:</p>

<p><code>_data: /storage/emulated/0/Pictures
_data: /storage/emulated/0/Music
_data: /storage/emulated/0/Notifications
_data: /storage/emulated/0/Pictures/picture.png</code></p>

<p>The result I'm wishing to achieve is</p>

<p><code>Music
Notifications
Pictures
picture.png</code></p>

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

<p>How may I achieve this behaviour directly from the database query?</p>