I can find the line I need through like , however, I need to get not the whole line (column of the line), but only the part where it is mentioned. For example, if we have the text:

"HashCode is a co-edited question-and-answer forum for beginners and experienced programmers. Join us!"

Then at the request of "answers" I want to see in response:

"questions and answers for beginners",

what would the user then output

"... questions and answers for beginners ...".

Base sqlite , Android platform

  • Do you need a SQL query that would cut and display the middle of the text or the post processing in Java? If the first, for which DBMS? - BiMaWa
  • What would bd herself. I wrote: "Base sqlite" - Anatoly Papenko
  • and you have already come up with a condition for which you will be displayed the correct number of words since the moment of coincidence? - Vladimir Klykov
  • And there is nothing that is: sqlite.org/lang_corefunc.html The function substr - BiMaWa
  • It does not work, sqlite does not have a built-in function to get the index of the substring. - falstaf

0