It is possible using ‘with recursive’. The following is ugly and inefficient but might give you some ideas.
with recursive cte (x,str) as (select 0,?1 union select x-1,substr(?1,x-1) from cte limit length(?1)) select str from cte where substr(str,1,2)='/*' order by -x limit 1; ________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Bart Smissaert <bart.smissa...@gmail.com> Sent: Friday, December 6, 2019 11:59:06 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] last occurrence of /* I think it can be done. Just dealing with the forward slash. RBS On Fri, Dec 6, 2019 at 11:49 PM Simon Slavin <slav...@bigfraud.org> wrote: > On 6 Dec 2019, at 11:00pm, Bart Smissaert <bart.smissa...@gmail.com> > wrote: > > > How do I select the part of this statement starting with the last /* ? > > Not in SQLite. Do it in your code, or write your own function to do it > and load this function into SQLite. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
