Hello! Using SQLite, can you use masks (or regex) (like '% str%') inside instr / substr, to delimit the output of a select, instead of me determining the beginning and end of the substring?
What I need (example): SELECT (substr (my_field, like% abc, until_next_spacechar_after (like% abc))) from my_table That is, after getting the start of the substring using a like mask, I want it from this point, the end of the substring to be the next character space. Thank you! _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users