Finding a sentence in a text using SQL?

Question

MySQL

Actually, the task is to isolate the sentence where the search phrase occurs using SQL in my case, MySQL and Sqlite.

For example:

Search field
"This is a test case for search. This sentence contains the search word. This is completely unnecessary."
Search query sentence

Expected result phrase

This sentence contains the search word

That is, the cutoff is roughly speaking for the group of characters ?!. and search expression.

Answer 1

SELECT LEFT( Text, LOCATE( 'поиска', Text ) + LENGTH ('поиска') - 1)
  FROM Texts
  WHERE Text LIKE '%поиска%'